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;

SELECT table_name FROM user_tables;

SELECT
  table_name, owner
FROM
  all_tables
ORDER BY
  owner, table_name

Source: chartio.com

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

0 vote346 views1 answer
Sql reverse order of results
SQL
0 vote331 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
2 votes380 views3 answers
Xampp mysql database not starting
SQL
0 vote382 views1 answer
Mariadb create index if not exists
SQL
0 vote326 views1 answer
Oracle index hint
SQL
23 votes355 views6 answers
How to create table in sql
SQL
0 vote343 views2 answers
What is the default password for sql server sa
SQL
1 vote348 views1 answer
Select dba users oracle
SQL
3 votes340 views1 answer
Sql server version query
SQL
1 vote350 views2 answers
How to combine 2 tables in MySQL
SQL