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 vote135 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote179 views1 answer
Delet all record statment sql
SQL
4 votes145 views3 answers
Employee name starting with in sql
SQL
0 vote134 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote152 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote138 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote139 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote138 views1 answer
Sql drop with dependencies
SQL
15 votes145 views2 answers
Sql order by multiple columns
SQL
4 votes171 views3 answers
Postgres drop all tables
SQL