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 vote211 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote210 views2 answers
Compound operator in sql
SQL
1 vote191 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
2 votes185 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote209 views1 answer
Mysql datetime with timezone offset
SQL
0 vote213 views1 answer
Postgres grep entire database
SQL
2 votes198 views1 answer
Wait delay in sql server
SQL
0 vote218 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
2 votes246 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes202 views1 answer
Orcale index size
SQL