/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 vote327 views2 answers
On update cascade
SQL
8 votes348 views1 answer
Oracle create datafile
SQL
0 vote312 views1 answer
Sql from null to not null
SQL
16 votes316 views2 answers
Gremove folder from git
SQL
0 vote385 views1 answer
How to find date from date table in sql
SQL
10 votes355 views4 answers
Drop primary key
SQL
5 votes365 views1 answer
Purge undo tablespace usage
SQL
0 vote348 views1 answer
Bidirectional outer join sql
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL
0 vote348 views3 answers
Delete in SQL SERVER
SQL