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 vote533 views2 answers
Create new table from existing table with data in sql server
SQL
3 votes338 views2 answers
Mysql create timestamp column
SQL
0 vote341 views1 answer
Populate db from command line postgres
SQL
7 votes342 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote335 views1 answer
Sql server select furst day of current year
SQL
2 votes330 views1 answer
Oracle index size calculation
SQL
2 votes338 views1 answer
When matched in sql server
SQL
31 votes326 views3 answers
Sql count(*)
SQL
0 vote315 views1 answer
Is not null postgresql
SQL
2 votes361 views1 answer
Revokeprivileges mysql
SQL