/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 vote348 views1 answer
Syntax for changing column size in mysql
SQL
5 votes376 views6 answers
In operator sql
SQL
0 vote369 views1 answer
How to get nth number in sql
SQL
0 vote359 views1 answer
Fill up postgres db
SQL
5 votes394 views1 answer
Get column name sql server
SQL
2 votes354 views2 answers
How to check data type in sql server
SQL
1 vote367 views1 answer
What is a Database?
SQL
1 vote351 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote399 views1 answer
Disable database droping sql
SQL
1 vote346 views1 answer
Mysql change root mysql_native_password
SQL