/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 vote205 views1 answer
Separator mysql
SQL
0 vote226 views1 answer
Add alternate add column sql
SQL
1 vote214 views1 answer
How to see all table partition in oracle
SQL
2 votes221 views1 answer
Codeigniter print last sql query
SQL
1 vote217 views1 answer
Show table columns
SQL
-1 vote232 views1 answer
Adding a new table psql
SQL
0 vote243 views1 answer
Mysql milliseconds
SQL
0 vote243 views1 answer
Write a query to peint the pattern P(20)
SQL
2 votes246 views2 answers
Postgres add column integer
SQL
2 votes291 views5 answers
Tablespace ORACLE
SQL