|
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>
|