list tables oracle code example
Example 1: oracle list tables
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: oracle all tables
-- NOTE: for Oracle ONLY
select *
from all_tables;