Create drop command by query the user_objects table : user_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_objects

SQL>
SQL>
SQL>
SQL>
SQL> SELECT    'DROP ' || object_type || ' ' || object_name || ';'
  2  FROM      user_objects
  3  WHERE     object_type IN ('PACKAGE','PACKAGE BODY','PROCEDURE',
  4                         'FUNCTION','TRIGGER')
  5  and       rownum < 50
  6  ORDER BY  object_type;

DROP FUNCTION CHITIME;
DROP FUNCTION RULERSTR;
DROP FUNCTION TO_NUMBER_OR_NULL;
DROP FUNCTION TRACEIT;
DROP FUNCTION TO_MMSDDSYYYY_OR_NULL;
DROP FUNCTION IS_OVERDUE;
DROP FUNCTION RECEIVE_MESSAGE;
DROP FUNCTION TABCOUNT;
DROP FUNCTION VALUE_IN;
DROP PACKAGE PARAMETERS;
DROP PACKAGE ONECUR;
DROP PACKAGE WORKER_TS;
DROP PACKAGE DATES;

DROP PACKAGE WORKPLACE_TYPE_TS;
DROP PACKAGE WORKER_TYPE_TS;
DROP PACKAGE VALERR;
DROP PACKAGE SCOPES;
DROP PACKAGE CLASSPACKAGE;
DROP PACKAGE GENDER_TS;
DROP PACKAGE BODY WORKER_TYPE_TS;
DROP PACKAGE BODY WORKER_TS;
DROP PACKAGE BODY GENDER_TS;
DROP PACKAGE BODY SCOPES;
DROP PACKAGE BODY PARAMETERS;
DROP PACKAGE BODY WORKPLACE_TYPE_TS;
DROP PACKAGE BODY DATES;

DROP PACKAGE BODY CLASSPACKAGE;
DROP PACKAGE BODY SALESPKG;
DROP PACKAGE BODY VALERR;
DROP PROCEDURE DROPIT;
DROP PROCEDURE FLUSH;
DROP PROCEDURE BULK_TEST;
DROP PROCEDURE CLOSECUR;
DROP PROCEDURE ROW_AT_A_TIME_TEST;
DROP PROCEDURE SAVESTRINGTOFILE;
DROP PROCEDURE PUT_BOOLEAN;
DROP PROCEDURE CREINDX;
DROP PROCEDURE GET_LINE;
DROP PROCEDURE P_RUN_INSERT;

DROP PROCEDURE P1;
DROP PROCEDURE WAIT;
DROP PROCEDURE SEND_MESSAGE;
DROP PROCEDURE PRINTLN;
DROP PROCEDURE DROP_IF_EXISTS;
DROP PROCEDURE SHOWEMPS;
DROP PROCEDURE DELETE_CUST;
DROP PROCEDURE FCREATE;
DROP PROCEDURE RUNDDL;
DROP PROCEDURE PROCA;

49 rows selected.

SQL>
SQL>