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