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

3 votes253 views6 answers
Jwt laravel
SQL
7 votes232 views3 answers
Convert ansi sql
SQL
1 vote245 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote218 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
-1 vote241 views1 answer
Pl sql drop trigger
SQL
0 vote219 views1 answer
Mysql remove tabs from string
SQL
0 vote224 views1 answer
Sql track modification
SQL
1 vote232 views1 answer
Mysql add fields
SQL
0 vote220 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote292 views1 answer
Trigger
SQL