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 vote120 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote116 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote187 views1 answer
Mysql select field if condition
SQL
25 votes133 views1 answer
How to update an attribute in MySQL
SQL
0 vote101 views1 answer
Mysql config address
SQL
0 vote113 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
7 votes113 views1 answer
Connect mysql docker
SQL
45 votes184 views5 answers
Grant all privileges mysql
SQL
0 vote98 views2 answers
Get top 1 row of each group
SQL
0 vote150 views1 answer
Sqlite display headers on columns
SQL