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 vote178 views1 answer
Postgres dump sql insert
SQL
17 votes128 views6 answers
Change column name in sql
SQL
0 vote129 views1 answer
Install squirrel sql ubuntu
SQL
27 votes142 views3 answers
Mysql show tables in database
SQL
0 vote78 views1 answer
'0000-00-00' for column '
SQL
0 vote116 views1 answer
How to check which sp is running in sql server
SQL
3 votes213 views1 answer
Postgresql today - 1 year
SQL
1 vote137 views1 answer
Sql view where tables have same column name combine results
SQL
2 votes148 views1 answer
Oracle kill session by sql_id
SQL
0 vote153 views1 answer
000webhost database values insert
SQL