/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 vote140 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
2 votes110 views1 answer
Change primary key sql
SQL
2 votes66 views1 answer
Oracle current date without time
SQL
1 vote98 views1 answer
Oracle sql create view
SQL
9 votes100 views2 answers
Sql server check table exists
SQL
0 vote120 views2 answers
Amazon linux postgresql client
SQL
3 votes216 views6 answers
Sql unique select
SQL
0 vote111 views1 answer
Mysql set boolean default value
SQL
0 vote97 views2 answers
Sql drop view if exists
SQL
12 votes102 views4 answers
How to take database dump in postgresql
SQL