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 vote233 views1 answer
Drop all procedures sql server
SQL
0 vote282 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote229 views1 answer
Postgres call view
SQL
4 votes248 views1 answer
Group by mysql and concatenate string
SQL
1 vote246 views1 answer
Where to locate set password for mysql
SQL
0 vote236 views1 answer
With_for_update sqlalchemy
SQL
0 vote249 views1 answer
Create table database in psql
SQL
0 vote198 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote229 views1 answer
In mysql workbench contnent not feching
SQL
2 votes201 views1 answer
Mysql admin u root p password change password
SQL