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

2 votes292 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote205 views1 answer
Mysql join column order By and group By
SQL
0 vote259 views1 answer
Using distinct and count together in sql
SQL
0 vote201 views1 answer
Create or replace view postgress
SQL
3 votes260 views2 answers
Find string in stored procedure sql server
SQL
0 vote267 views1 answer
Manage Database in MySQL
SQL
4 votes215 views1 answer
Oracle nls_date_format
SQL
1 vote219 views1 answer
Postgres install unaccent extension
SQL
0 vote205 views1 answer
Sql server union if table exist
SQL
19 votes201 views6 answers
What is mySQL
SQL