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 vote210 views3 answers
Condition in count sql
SQL
0 vote169 views1 answer
Tsql generate rows
SQL
0 vote180 views1 answer
Sql tabelle erstellen
SQL
2 votes185 views6 answers
In in sql
SQL
0 vote177 views1 answer
Check psql validity function
SQL
0 vote227 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote181 views1 answer
How to select random rows from table
SQL
0 vote273 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote190 views1 answer
How to write if case in select query in select statement
SQL
2 votes179 views1 answer
Rails execute sql
SQL