see all tables in the database in oracle sql code example Example: oracle all tables -- NOTE: for Oracle ONLY select * from all_tables;