get all table names oracle code example
Example 1: SELECT table_name FROM user_tables;
SELECT
table_name, owner
FROM
user_tables
ORDER BY
owner, table_name
Example 2: oracle all tables
-- NOTE: for Oracle ONLY
select *
from all_tables;
SELECT
table_name, owner
FROM
user_tables
ORDER BY
owner, table_name
-- NOTE: for Oracle ONLY
select *
from all_tables;