DECLARE CURSOR CC IS SELECT * FROM ALL_OBJECTS WHERE OWNER='ANAR'; ----- My user BEGIN FOR I IN 1..5 LOOP FOR II IN CC LOOP BEGIN EXECUTE IMMEDIATE 'DROP '||II.OBJECT_TYPE||' '||II.OWNER||'.'||II.OBJECT_NAME; DBMS_OUTPUT.PUT_LINE(II.OBJECT_TYPE||' '||II.OWNER||'.'||II.OBJECT_NAME); EXCEPTION WHEN OTHERS THEN NULL; END; END LOOP; END LOOP; END;
Advertisements