/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 vote147 views1 answer
Executescalar in sql server
SQL
8 votes129 views1 answer
Oracle search source code
SQL
1 vote139 views1 answer
How to set up a trigger in sql
SQL
2 votes128 views2 answers
Postgres select duplicate columns
SQL
0 vote168 views1 answer
Store case result sql
SQL
1 vote218 views1 answer
Oracle current sequence value
SQL
0 vote141 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote132 views2 answers
Mysql get routine parameter list
SQL
7 votes139 views1 answer
Query delete duplicates
SQL
0 vote136 views1 answer
Group by join columns per table
SQL