/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

2 votes175 views1 answer
Anonymous block plsql
SQL
1 vote182 views2 answers
Mysql trim spaces
SQL
0 vote177 views1 answer
Oracle sql date winter time
SQL
1 vote195 views1 answer
Oracle grant select on schema
SQL
0 vote150 views1 answer
Mariadb list tables
SQL
0 vote176 views1 answer
Mysql 1 hour ago
SQL
0 vote195 views1 answer
Providername system.data. mysql
SQL
-1 vote172 views2 answers
Full join sql
SQL
0 vote174 views1 answer
Oracle synonym procedure
SQL
0 vote223 views1 answer
Sql doesn't contain
SQL