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

5 votes198 views3 answers
Sql make column nullable
SQL
0 vote265 views1 answer
Count database access django
SQL
0 vote364 views1 answer
Sql change a colum to unique
SQL
3 votes231 views1 answer
Set default today mysql
SQL
0 vote200 views1 answer
How to query without duplicate rows in sql
SQL
7 votes206 views2 answers
Oracle sql drop index
SQL
3 votes196 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote234 views1 answer
Mysql limit order by
SQL
0 vote192 views3 answers
Get free card roblox
SQL
2 votes222 views1 answer
Import large .sql files into lampp
SQL