/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 vote174 views1 answer
Round up and down sql
SQL
0 vote169 views1 answer
Sql remove decimal places
SQL
1 vote160 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote178 views1 answer
Oracle synonym procedure dblink
SQL
0 vote154 views1 answer
Generate sequence number in sql server
SQL
10 votes168 views1 answer
Create table oracle
SQL
7 votes164 views4 answers
How to reset the identity column in sql server
SQL
16 votes170 views3 answers
Tsql rename column name
SQL
0 vote187 views1 answer
The package java.sql is not accessible
SQL
0 vote171 views1 answer
Fill up postgres db
SQL