SELECT * FROM ALL_TABLES;
SELECT table_name, owner FROM all_tables ORDER BY owner, table_name
-- NOTE: for Oracle ONLY select * from all_tables;