/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

4 votes109 views1 answer
Sql group by year
SQL
2 votes122 views1 answer
Apex execute batch job
SQL
0 vote120 views2 answers
2nd max salary query in sql
SQL
1 vote121 views1 answer
Oracle turn off constraint
SQL
2 votes106 views1 answer
Oracle sql day of month from date
SQL
0 vote109 views1 answer
Mysql group rows with same value
SQL
0 vote80 views1 answer
Update set with join pl sql
SQL
1 vote110 views1 answer
Oracle aleter trigger ora-01031
SQL
5 votes116 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote261 views1 answer
Dublicate row sql
SQL