/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 vote203 views1 answer
Kill a pid redshift
SQL
0 vote193 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote204 views1 answer
Mysql last friday of current month
SQL
1 vote241 views1 answer
Import sql file from laravel
SQL
2 votes207 views1 answer
Dbms transaction (psql)
SQL
0 vote198 views1 answer
Sql server count all tables rows
SQL
0 vote200 views1 answer
Alter database name script
SQL
18 votes196 views4 answers
Mysql current date between two dates
SQL
4 votes203 views4 answers
Start mysql
SQL
1 vote188 views1 answer
How to select random rows from table
SQL