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

4 votes79 views1 answer
Generate class from sql table c#
SQL
0 vote125 views1 answer
Mysql connection with sqlalchecmy
SQL
1 vote146 views1 answer
Sample clause in sql
SQL
11 votes138 views2 answers
Safe mode off mysql
SQL
1 vote96 views1 answer
Unique vs distinct sql
SQL
0 vote90 views1 answer
Update set with join pl sql
SQL
-1 vote108 views2 answers
Sql query examples
SQL
1 vote120 views1 answer
Sql server 2012 query history
SQL
0 vote125 views2 answers
Plsql regex match whole word
SQL
-1 vote147 views1 answer
Mysql coalesce
SQL