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

20 votes149 views6 answers
Mysql reset auto increment
SQL
3 votes184 views1 answer
How to get yesterday date in sql
SQL
4 votes132 views1 answer
Sql any
SQL
0 vote136 views1 answer
How to check even or odd in sql
SQL
0 vote133 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
2 votes127 views1 answer
Sql update alias
SQL
0 vote161 views1 answer
Table user postgres
SQL
0 vote162 views1 answer
Implode in sql query
SQL
4 votes156 views3 answers
Mysql get column names from table
SQL
1 vote140 views1 answer
Multiple count in sql
SQL