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 votes110 views3 answers
Mysql check if null or empty string
SQL
34 votes159 views6 answers
Alter table add foreign key mysql
SQL
7 votes119 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
23 votes108 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
7 votes122 views1 answer
Set sequence value oracle
SQL
0 vote128 views1 answer
How to list function in psql
SQL
20 votes131 views4 answers
Sql count if
SQL
4 votes109 views1 answer
Alter session set nls_date_format
SQL
1 vote118 views2 answers
How to enable error squiggles in vs code
SQL
0 vote110 views1 answer
Sql count null as 0
SQL