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

10 votes174 views3 answers
Sql select between two dates
SQL
14 votes218 views5 answers
Set password for postgres user ubuntu
SQL
0 vote162 views1 answer
Join in update query in mysql
SQL
1 vote190 views1 answer
Mysql workbench in ubuntu 14.04
SQL
18 votes171 views6 answers
Create table mysql
SQL
0 vote177 views1 answer
Alter table add check constraint oracle
SQL
0 vote184 views1 answer
Helptext in sql
SQL
0 vote163 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote194 views1 answer
Sql datum formatieren
SQL
0 vote168 views4 answers
Forenkey code alchemy sql
SQL