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 vote354 views1 answer
Postgres drop type
SQL
0 vote365 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote362 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote354 views2 answers
How to set global time_zone in mysql
SQL
0 vote366 views1 answer
Creating h2 database in relative directory eclopse
SQL
2 votes346 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote375 views1 answer
Mysql select from outside
SQL
3 votes358 views5 answers
Foreign keys
SQL
0 vote337 views3 answers
Between keyword sql
SQL
3 votes334 views2 answers
Pl sql escape '
SQL