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 vote356 views2 answers
Close external port 3306 with iptables
SQL
1 vote362 views1 answer
Postgresql blocked on mac
SQL
1 vote350 views1 answer
Funzioni plsql
SQL
0 vote386 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote364 views1 answer
Heidisql check how much space a row
SQL
1 vote344 views1 answer
Sql group by error
SQL
0 vote349 views1 answer
What is mysql_pconnect
SQL
5 votes358 views1 answer
How to check nls format in oracle
SQL
3 votes368 views1 answer
Oracle list user grants
SQL
1 vote369 views1 answer
Oracle stop
SQL