/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 votes294 views1 answer
Mariadb select multiple rows into one column
SQL
-2 votes293 views3 answers
Sqlite reset autoincrement
SQL
0 vote314 views1 answer
Excel vba import data to sql server
SQL
0 vote279 views1 answer
Mysql with
SQL
3 votes293 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote286 views1 answer
Oracle start job
SQL
3 votes306 views2 answers
How to load files in mysql
SQL
4 votes331 views1 answer
Sql delete multiple conditions
SQL
0 vote335 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote354 views1 answer
Pagination with row_number
SQL