Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

If trigger exists, drop trigger

SQL> SQL> BEGIN   2    FOR i IN (SELECT null FROM user_triggers WHERE trigger_name = 'INSERTemp') LOOP   3      EXECUTE IMMEDIATE 'DROP TRIGGER InsertBooksemp';   4    END LOOP;   5  END;   6  / PL/SQL procedure successfully completed. SQL>