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

4 votes136 views2 answers
Postgresql default value
SQL
0 vote130 views1 answer
How to find columns with null values in sql
SQL
4 votes132 views1 answer
Data types in sql
SQL
0 vote122 views1 answer
Sql remove last x char
SQL
1 vote122 views1 answer
Mysql check if string contains comma separated
SQL
0 vote137 views1 answer
Oracle running queries sql
SQL
0 vote149 views1 answer
Savepoint mysql script
SQL
0 vote128 views2 answers
Sql query inner join 3 tables
SQL
10 votes128 views6 answers
Between sql
SQL
1 vote154 views1 answer
How to get alternate records from a table in sql
SQL