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

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

0 vote170 views1 answer
Check index sql server
SQL
16 votes242 views6 answers
Mysql find duplicates in same table
SQL
7 votes180 views1 answer
Postgres base size
SQL
1 vote167 views1 answer
Importance of comment in mysql
SQL
0 vote174 views1 answer
Postgres float to int
SQL
1 vote184 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
13 votes179 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote183 views1 answer
Windows services sql
SQL
0 vote175 views1 answer
Table or view does not exist
SQL
6 votes182 views3 answers
Mysql first day of year
SQL