/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 vote311 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote314 views2 answers
Sql server select where date
SQL
2 votes331 views2 answers
Created at and updated at in mysql
SQL
2 votes311 views1 answer
Oracle index size
SQL
5 votes317 views1 answer
Mysql change primary key
SQL
0 vote334 views1 answer
Alter column to not null with default value sql server
SQL
2 votes303 views1 answer
Sql find missing values between two tables
SQL
1 vote331 views1 answer
Postgresql datetrunc too slow
SQL
0 vote324 views1 answer
Oracle running queries sql
SQL
0 vote321 views1 answer
No suitable driver found for sqlite
SQL