/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
Sql get count without group by
SQL
8 votes204 views1 answer
Show mysql user table
SQL
0 vote233 views1 answer
How to print some string in mysql
SQL
0 vote197 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
3 votes186 views1 answer
Oracle rollback
SQL
0 vote235 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote189 views1 answer
Postgres data location
SQL
1 vote208 views1 answer
Tsql update datetime
SQL
9 votes198 views4 answers
Mysql show table fields
SQL
0 vote210 views1 answer
Mysql into outfile with headers
SQL