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 vote181 views1 answer
Load data from text file to mysql database on mac terminal
SQL
5 votes164 views1 answer
List foreign key oracle
SQL
0 vote168 views1 answer
Create new schema mysql
SQL
0 vote171 views1 answer
Sql quary intervewi question
SQL
2 votes212 views3 answers
How do I add a user to a postgres database? cli
SQL
5 votes187 views6 answers
Sql foreign key
SQL
0 vote173 views1 answer
Default order by in mysql
SQL
1 vote167 views1 answer
How to start with sql
SQL
1 vote178 views3 answers
Sql union
SQL
1 vote166 views2 answers
Mysql allow remote connections
SQL