1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
DECLARE BEGIN FOR eachObject IN ( SELECT 'DROP ' || object_type || ' ' || object_name || DECODE ( object_type, 'TABLE', ' CASCADE CONSTRAINTS PURGE' ) AS statement_sql FROM user_objects WHERE object_type IN ( 'TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'TRIGGER', 'SEQUENCE' ) ORDER BY object_type, object_name ) LOOP EXECUTE IMMEDIATE eachObject.statement_sql; END LOOP; END; / |