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 vote408 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote342 views1 answer
Sql where time stamp is in between
SQL
0 vote335 views1 answer
Renommer table sql
SQL
0 vote351 views2 answers
How to update the multiple rows in sql
SQL
31 votes382 views2 answers
Grant all priviledges to mysql user
SQL
0 vote367 views1 answer
Mysql repair a table
SQL
0 vote357 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
8 votes419 views2 answers
Default sql server port
SQL
1 vote350 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote381 views1 answer
Sql server insert inner join
SQL