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 votes198 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote257 views1 answer
Sql to excel pgadmin
SQL
0 vote252 views1 answer
Postgresql select fast check no rows
SQL
0 vote195 views2 answers
Auto increment column in mysql query results
SQL
-1 vote211 views1 answer
Select first rows postgresql
SQL
0 vote213 views1 answer
Big table in mysql
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
0 vote194 views2 answers
Sql count number of rows after group by
SQL
0 vote228 views1 answer
Sql select sum group by id laravel join
SQL
0 vote199 views1 answer
MySQL INSERT IGNORE Statement
SQL