Show tables 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

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Show tables in schema oracle

SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
--GET TABLE NAMES OF A SCHEMA IN ORACLE

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Show tables in oracle

select * from tab;

Similar codes

0 vote164 views1 answer
Compare field sql server
SQL
2 votes172 views1 answer
Date_format for time sql
SQL
2 votes172 views3 answers
Postgresql reset auto increment
SQL
35 votes182 views6 answers
Postgres
SQL
9 votes165 views3 answers
Mysql show table column full description
SQL
0 vote180 views1 answer
Insert or update sql firebird
SQL
22 votes173 views6 answers
Create sql table
SQL
0 vote155 views1 answer
List MySQL Table and Index Size
SQL
0 vote186 views1 answer
Dual in db2
SQL
0 vote201 views1 answer
Sql alter column name sql server
SQL