/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 vote350 views3 answers
What is union in sql
SQL
0 vote342 views1 answer
WHERE not regex in SQL
SQL
0 vote332 views1 answer
Set mysql socket file docker windows
SQL
1 vote350 views1 answer
Postgres power
SQL
3 votes352 views2 answers
Sql end of month
SQL
0 vote371 views1 answer
How to run mysql on terminal mac
SQL
0 vote317 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote331 views1 answer
Get rows affected mysql python
SQL
6 votes337 views1 answer
Oracle desc table primary key
SQL
0 vote342 views1 answer
Vowels in sql
SQL