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 vote276 views1 answer
Sql change default collation to utf8
SQL
3 votes444 views9 answers
Linq to sql converter online
SQL
0 vote307 views3 answers
Mysql regex replace
SQL
13 votes308 views2 answers
Sql join 3 tables
SQL
0 vote285 views1 answer
Sql server remove 0 from left
SQL
2 votes243 views1 answer
Sql view column data type
SQL
3 votes313 views1 answer
Get current month last date in sql server
SQL
0 vote287 views1 answer
Composit key in sql
SQL
1 vote298 views1 answer
Select count distinct multiple columns sql server
SQL
4 votes282 views1 answer
Sql data types
SQL