/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

11 votes167 views2 answers
Sql rank
SQL
2 votes200 views1 answer
Oracle Column Names of a table
SQL
0 vote191 views1 answer
Kimball data warehouse sql calendar
SQL
4 votes151 views2 answers
Oracle set date format
SQL
0 vote154 views2 answers
Many to many flask-sqlalchemy
SQL
3 votes151 views1 answer
Oracle sleep
SQL
0 vote161 views1 answer
Drop unique
SQL
0 vote151 views1 answer
Oracle query archivemode
SQL
0 vote154 views2 answers
How to count codition
SQL
0 vote148 views1 answer
Call function in query sql server
SQL