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

3 votes154 views4 answers
Show databases in sql server
SQL
0 vote143 views1 answer
Order by monthly in sql
SQL
1 vote161 views1 answer
Mysql add fields
SQL
0 vote144 views1 answer
Mysql show category once count how many products
SQL
3 votes149 views3 answers
Mysql select table names
SQL
0 vote143 views1 answer
Inner joint
SQL
13 votes177 views3 answers
List all the tables in sql
SQL
0 vote162 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote160 views1 answer
Sql server update column based on another table
SQL
0 vote151 views1 answer
Create a PostgreSQL user django on mac
SQL