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

21 votes194 views6 answers
Update sql
SQL
9 votes169 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
7 votes186 views3 answers
Python and mysql connectivity
SQL
0 vote187 views3 answers
Magento 2 order delete from db
SQL
-1 vote188 views1 answer
Extract Data from SQL Server into XML Format
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL
2 votes185 views1 answer
How to get non distinct values in sql
SQL
1 vote190 views1 answer
Snowflake rename column name
SQL
0 vote189 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote178 views1 answer
Sql select lowest value row
SQL