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 vote297 views1 answer
Typical max-connect-errors mysql
SQL
6 votes261 views4 answers
Mysql group by month
SQL
19 votes279 views3 answers
Grant mysql
SQL
0 vote273 views1 answer
Sqlite unique multiple columns
SQL
0 vote248 views1 answer
Find wordpress version in database
SQL
1 vote257 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote260 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote250 views1 answer
Uuid sqlalcomany
SQL
9 votes275 views6 answers
Check constraint in sql
SQL
7 votes263 views1 answer
Sql limit decimal places
SQL