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