/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

14 votes279 views4 answers
Online sql compiler
SQL
4 votes253 views1 answer
Update table from another table oracle
SQL
1 vote284 views1 answer
Oracle select row max date
SQL
0 vote275 views1 answer
How to execute stored output to csv files
SQL
17 votes286 views4 answers
Sort by mysql
SQL
0 vote358 views1 answer
Create view in sql server that contain multiple select statements
SQL
3 votes269 views3 answers
How to add month in update sql
SQL
0 vote273 views1 answer
How to reset table in sql server
SQL
0 vote282 views1 answer
Postgresql show owner of database
SQL
3 votes265 views1 answer
Oracle get trigger ddl
SQL