/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

0 vote120 views1 answer
Connecting to my cloud sql server with c#
SQL
-1 vote120 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote147 views1 answer
Repeatable read trong sql server
SQL
0 vote132 views1 answer
Sql last 3 rows
SQL
0 vote112 views1 answer
Dasebase_url-postgres for windows
SQL
7 votes223 views2 answers
Sql empty table
SQL
-1 vote124 views1 answer
How to open blade file from blade in laravel
SQL
1 vote128 views2 answers
Sql left characters
SQL
4 votes121 views1 answer
Sql delete where in select
SQL
1 vote125 views2 answers
Difference between in and between in sql
SQL