see all tables in oracle sql code example
Example 1: show all tables in oracle
SELECT * FROM USER_TABLES; ' Tables from your schema
SELECT * FROM ALL_TABLES; ' Tables from schemas you can access
SELECT * FROM DBA_TABLES; ' All Tables
Example 2: show all tables in oracle
SELECT * FROM ALL_TABLES;
Example 3: SELECT table_name FROM user_tables;
SELECT
table_name, owner
FROM
all_tables
ORDER BY
owner, table_name
Example 4: SELECT table_name FROM user_tables;
SELECT
table_name, owner
FROM
user_tables
ORDER BY
owner, table_name
Example 5: oracle all tables
select *
from all_tables;