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 vote124 views1 answer
Mssql check if date is greater than today
SQL
2 votes122 views1 answer
Apex execute batch job
SQL
0 vote112 views1 answer
Sql DATE = GETDATE()
SQL
0 vote118 views1 answer
Mysql milliseconds
SQL
7 votes130 views2 answers
Where keyword sql
SQL
24 votes117 views4 answers
Mssql get all table names
SQL
1 vote362 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote148 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote146 views1 answer
Sql to excel pgadmin
SQL
1 vote103 views1 answer
Sql server 2016 reseed identity
SQL