/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 vote108 views1 answer
How to create an SQL save method in ruby
SQL
0 vote113 views1 answer
What is between keyword used for
SQL
0 vote135 views1 answer
Procedures sql insert mysql
SQL
4 votes132 views1 answer
Postgres delete last row
SQL
0 vote112 views1 answer
SQL Server Enterprise
SQL
0 vote123 views1 answer
Window function to forward fill
SQL
8 votes110 views3 answers
Alter user root mysql
SQL
0 vote116 views1 answer
Replace sqlalchemy
SQL
12 votes120 views6 answers
How to install sqlite3 in python
SQL
1 vote122 views1 answer
Sql order by timestamp
SQL