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 vote162 views1 answer
Select multiple row from primary key sql
SQL
1 vote217 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote148 views1 answer
Postgres 11 add primary key
SQL
0 vote151 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote149 views1 answer
Utiliser sql ligne de commande
SQL
3 votes153 views3 answers
Stop mysql service ubuntu
SQL
0 vote140 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
2 votes145 views1 answer
Cast string to datetime mysql
SQL
4 votes139 views1 answer
Postgresql show current database
SQL
0 vote154 views1 answer
Rename view mysql
SQL