/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

16 votes289 views6 answers
Mysql find and replace
SQL
0 vote287 views1 answer
How get data from database if id not found then search another column
SQL
0 vote287 views2 answers
Sql join on comma separated field
SQL
0 vote311 views1 answer
Doctors appointment
SQL
0 vote306 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote306 views1 answer
SQL division of an integer by another integer get float CAST
SQL
7 votes292 views3 answers
Add primary key to database sql
SQL
0 vote343 views1 answer
Sql query to select even numbers
SQL
0 vote308 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote288 views2 answers
Sql query for getting details by id
SQL