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

1 vote278 views1 answer
Oracle stop job
SQL
1 vote320 views1 answer
Postgresql float 2 decimal places
SQL
4 votes280 views1 answer
Sql group by year
SQL
0 vote274 views1 answer
Mysqldump don't drop table
SQL
0 vote313 views1 answer
Offset in postgresql example
SQL
0 vote293 views1 answer
Object of class mysqli_result could not be converted to string
SQL
3 votes290 views1 answer
Créer une table sql
SQL
2 votes280 views1 answer
Mysql find tables with name
SQL
0 vote293 views1 answer
Sql check for null and empty string
SQL
1 vote307 views5 answers
What is in operator in sql
SQL