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 vote316 views1 answer
Copy Table from SQL to CSV
SQL
0 vote317 views2 answers
Select index table oracle
SQL
1 vote308 views3 answers
Mysql disable foreign keys check
SQL
5 votes366 views2 answers
Add days in oracle sql
SQL
0 vote299 views1 answer
Changer un mot de passe mysql
SQL
-1 vote321 views4 answers
Restart mysql server ubuntu
SQL
0 vote307 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote312 views1 answer
Java spring boot connect to sql server
SQL
7 votes305 views2 answers
N highest salary in sql
SQL
1 vote320 views1 answer
Select not matching data with join table
SQL