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 vote270 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
5 votes240 views6 answers
Sql add days to date
SQL
3 votes244 views1 answer
Oracle list invalid password ORA-01017
SQL
5 votes264 views1 answer
Sort order on two columns sql
SQL
-1 vote311 views5 answers
Left join sql
SQL
11 votes271 views2 answers
How to import mysql database command line
SQL
1 vote239 views1 answer
Oracle start job
SQL
3 votes251 views3 answers
Update join
SQL
0 vote271 views3 answers
Sql query checker
SQL
0 vote278 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL