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 vote265 views1 answer
Primary key start from number
SQL
0 vote241 views1 answer
Initcap in mysql
SQL
10 votes256 views2 answers
Tsql merge example
SQL
0 vote243 views1 answer
Oracle array
SQL
3 votes220 views1 answer
Oracle function
SQL
2 votes229 views1 answer
Sql server check for value in multiple columns
SQL
22 votes264 views3 answers
Year format in date mysql
SQL
1 vote264 views1 answer
Sql check roles
SQL
0 vote289 views1 answer
How to find unique element in sql
SQL
0 vote236 views2 answers
Getting customers with no orders sql
SQL