Oracle all tables in schema

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All database Tables

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

0 vote228 views1 answer
Postgres get running query
SQL
0 vote166 views1 answer
Oracle current timestamp
SQL
0 vote196 views1 answer
Oracle chain step succeeded
SQL
0 vote218 views1 answer
Capabilities of sql select statements
SQL
0 vote233 views1 answer
Mariadb used space
SQL
0 vote172 views2 answers
Pop sql insert value into
SQL
1 vote172 views2 answers
Postgresql list columns
SQL
5 votes173 views2 answers
Sql create tabel with primary key auto_increment code
SQL
13 votes178 views1 answer
Views in sql
SQL
0 vote178 views1 answer
Rename constraint postgresql
SQL