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 vote302 views3 answers
Java hide mysql login credentials
SQL
1 vote273 views1 answer
Delete mysql from mac
SQL
0 vote271 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote280 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote327 views1 answer
How to inner join 4 tables in sql
SQL
0 vote308 views1 answer
Add a new column into table
SQL
0 vote319 views1 answer
Use mysql in java program
SQL
0 vote279 views1 answer
Sql insert tuple
SQL
0 vote298 views1 answer
Postgres row expiration
SQL
1 vote276 views1 answer
How to select department from table
SQL