Show tables in schema oracle

Oracle all tables in schema

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 tables in schema oracle

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

Similar codes

5 votes123 views6 answers
Sql foreign key
SQL
0 vote123 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote103 views1 answer
Postgresql using reserved word as column name
SQL
0 vote137 views1 answer
Postgres dump sql insert
SQL
0 vote105 views1 answer
Implicit inner join table alias
SQL
2 votes97 views2 answers
Postgres select duplicate columns
SQL
0 vote101 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote105 views1 answer
Copying query result to excel
SQL
1 vote114 views1 answer
How to unlock table in mysql
SQL
0 vote103 views1 answer
Mysql dump everythign
SQL