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

0 vote168 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote147 views1 answer
Sql date between one week
SQL
1 vote156 views1 answer
Rails run native ssql query
SQL
12 votes161 views2 answers
Select into insert sql server
SQL
8 votes205 views2 answers
Default sql server port
SQL
-1 vote106 views2 answers
Datetime sql server week
SQL
7 votes184 views1 answer
Sql disable safe mode
SQL
0 vote169 views1 answer
How to check default value of column in sql server
SQL
-1 vote163 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
10 votes156 views4 answers
Sql pagination
SQL