/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 vote187 views1 answer
How to check which table has data in mysql
SQL
7 votes179 views4 answers
Index in mysql
SQL
11 votes163 views2 answers
Oracle all source
SQL
0 vote134 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
6 votes169 views4 answers
Mysql update set
SQL
0 vote187 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
4 votes164 views3 answers
Create database in mySQL
SQL
0 vote167 views1 answer
Stored procedure function relation
SQL
0 vote162 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote215 views1 answer
Postgresql import data from csv
SQL