Oracle DB: Delete all user objects (Tables, Views, Procedures, Functions, Sequences, Types, Packages)

deleteAllUserObjects.sql

BEGIN
   FOR record IN (SELECT object_name, object_type
                     FROM user_objects
                    WHERE object_type IN
                             ('TABLE',
                              'VIEW',
                              'PROCEDURE',
                              'FUNCTION',
                              'SEQUENCE',
			      'TYPE',
			      'PACKAGE'
                             ))
   LOOP
      BEGIN
         IF record.object_type = 'TABLE'
         THEN
            EXECUTE IMMEDIATE    'DROP '
                              || record.object_type
                              || ' "'
                              || record.object_name
                              || '" CASCADE CONSTRAINTS';
         ELSE
            EXECUTE IMMEDIATE    'DROP '
                              || record.object_type
                              || ' "'
                              || record.object_name
                              || '"';
         END IF;
      EXCEPTION
         WHEN OTHERS
         THEN
            DBMS_OUTPUT.put_line (   'FAILED: DROP '
                                  || record.object_type
                                  || ' "'
                                  || record.object_name
                                  || '"'
                                 );
      END;
   END LOOP;
END;
/