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 vote307 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote314 views1 answer
How to check rollback status in oracle
SQL
0 vote267 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote279 views2 answers
Sql trigger difference between for and after
SQL
0 vote272 views1 answer
Group by sql not ordering issues
SQL
0 vote265 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote278 views2 answers
Postgres default user
SQL
0 vote288 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
2 votes298 views1 answer
Oracle insert or update
SQL
1 vote275 views1 answer
Sample clause in sql
SQL