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

4 votes229 views1 answer
Oracle nls_date_format
SQL
5 votes215 views4 answers
Change auto increment mysql
SQL
1 vote216 views1 answer
Postgresql delete cascade
SQL
0 vote215 views1 answer
Name '_mysql' is not defined
SQL
5 votes193 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote214 views1 answer
Remove transient options sql wordpress
SQL
0 vote201 views1 answer
Mysql server not running
SQL
0 vote202 views1 answer
Update top 100 order by sql server
SQL
8 votes222 views1 answer
Oracle search stored procedures for text
SQL
0 vote228 views1 answer
Carbon mysql d m y to y-m-d
SQL