/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 vote196 views1 answer
Group by two columns postgres
SQL
0 vote212 views1 answer
Postgresql list extensions
SQL
0 vote187 views1 answer
Mysql search multiple tables
SQL
1 vote219 views1 answer
Oracle compile schema
SQL
10 votes197 views4 answers
Primary key sql
SQL
4 votes190 views1 answer
Postgres delete last row
SQL
0 vote201 views1 answer
Oracle procedure chain step
SQL
0 vote206 views1 answer
Update view sql
SQL
1 vote211 views1 answer
Add multiple row table pl sql
SQL
3 votes231 views1 answer
Set default today mysql
SQL