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

2 votes214 views2 answers
How to rename column name in sql server using query
SQL
-1 vote259 views1 answer
Difference berween database and data base management system
SQL
0 vote222 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote232 views2 answers
Snowflake alter column data type
SQL
0 vote235 views1 answer
Oracle insert single quote in string
SQL
3 votes234 views2 answers
Update part of a string in mysql
SQL
16 votes215 views1 answer
Mssql int max value
SQL
3 votes208 views2 answers
Mysql HAVING
SQL
2 votes222 views1 answer
How to insert string variable into sqlite database
SQL
0 vote206 views1 answer
Postgresql find missing id
SQL