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 vote314 views1 answer
Mysql select all table that have field names
SQL
1 vote344 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote327 views1 answer
Database db connection string format
SQL
1 vote373 views1 answer
Sql select sum group by id laravel
SQL
0 vote330 views1 answer
Oracle remove line breaks
SQL
1 vote314 views1 answer
Tsql create unique index composite
SQL
0 vote341 views1 answer
Select true if exists on another table or false sqlserver
SQL
1 vote322 views1 answer
What is int in mysql
SQL
1 vote312 views5 answers
Sql 2nd highest salary
SQL
0 vote292 views1 answer
Generate sequence number in sql server
SQL