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

-1 vote264 views2 answers
Installing mysql on centos 7
SQL
0 vote282 views1 answer
Sparql list all graphs
SQL
0 vote221 views1 answer
Oracle activate program
SQL
2 votes255 views2 answers
Mysql count rows returned
SQL
5 votes248 views1 answer
Oracle sysdate - 1 month
SQL
14 votes238 views1 answer
Oracle new column
SQL
56 votes413 views5 answers
Psql create user
SQL
1 vote261 views1 answer
Last 24 HOUR data in mysql
SQL
5 votes253 views1 answer
Oracle nls session
SQL
3 votes246 views2 answers
Monthname sql
SQL