/SQL/How to get all the tables displayed in oracle

How to get all the tables displayed in oracle

Show all tables in oracle

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

Source: grepper.com

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Source: grepper.com

Similar codes

-1 vote187 views5 answers
Not in sql
SQL
0 vote180 views1 answer
ORA-13717
SQL
0 vote176 views1 answer
Show size of all tables postgres
SQL
0 vote181 views1 answer
Oracle archivemode
SQL
0 vote185 views1 answer
Oracle exchange subpartition
SQL
3 votes204 views2 answers
Mysql select database
SQL
2 votes178 views2 answers
Sql first character
SQL
-1 vote234 views3 answers
MAKE TABLE FIT in oracle sql
SQL
4 votes312 views1 answer
Oracle table statistics
SQL
-1 vote192 views1 answer
Window functions in sql
SQL