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 vote297 views2 answers
Postgresql variable in query
SQL
0 vote306 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote272 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote271 views1 answer
How to put is null in where in clause
SQL
0 vote292 views1 answer
QCompleter con sql
SQL
1 vote285 views1 answer
Oracle extract minute from date
SQL
1 vote290 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote295 views1 answer
Sql today at midnight
SQL
2 votes289 views1 answer
Sql server case sensitive search
SQL
1 vote275 views1 answer
Mysql best tutorial for beginners
SQL