/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

1 vote178 views1 answer
Mysql update inner
SQL
0 vote169 views1 answer
Mysql insert into select with recursive
SQL
1 vote167 views1 answer
Mysql add fields
SQL
0 vote176 views1 answer
Query to remove duplicate rows from a table
SQL
1 vote156 views1 answer
Get table which have specific columns in mysql
SQL
0 vote156 views1 answer
Split string by comma in sql server
SQL
0 vote164 views1 answer
How to put is null in where in clause
SQL
0 vote151 views1 answer
Groupby error in mysql
SQL
6 votes154 views1 answer
Oracle trigger after connect
SQL
0 vote165 views1 answer
Mysql update set sum
SQL