Show tables in oracle

Show all tables in oracle

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

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Show tables in schema oracle

SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
--GET TABLE NAMES OF A SCHEMA IN ORACLE

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Show tables in oracle

select * from tab;

Similar codes

0 vote219 views1 answer
Executescalar in sql server
SQL
2 votes179 views2 answers
How to get capital letter first in sql
SQL
0 vote287 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote200 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote217 views2 answers
Insert data mysql with cmd
SQL
0 vote211 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote226 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
2 votes223 views1 answer
Oracle list duplicates
SQL
0 vote195 views1 answer
Get all employees if name ends with in sql
SQL
1 vote190 views1 answer
How refresh navicat tables to see new tables
SQL