/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

1 vote183 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote171 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote209 views1 answer
Find duplicate users by email address in mysql
SQL
10 votes192 views4 answers
Inner join in update query mysql
SQL
3 votes265 views1 answer
Oracle show trigger code
SQL
0 vote161 views1 answer
Mysql disable query caching
SQL
0 vote196 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote267 views1 answer
Jpa generationtype sequence mysql
SQL
16 votes194 views1 answer
Mysql smallint range
SQL
0 vote181 views1 answer
Extract sql from query object sqlalchemy
SQL