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 vote176 views1 answer
Raiserror with nowait
SQL
0 vote183 views1 answer
Docker open terminal mysql server
SQL
0 vote186 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote175 views1 answer
Every Derived yable must have its own alias
SQL
36 votes173 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote150 views1 answer
Oracle lock user
SQL
0 vote178 views1 answer
SQL: calculate hours from two dates
SQL
2 votes222 views1 answer
Merge two columns in sql oracle
SQL
3 votes182 views2 answers
Postgresql select all column names
SQL
2 votes185 views3 answers
Row number mysql
SQL