Oracle PL/SQL Tutorial/Trigger/Drop Trigger

Dropping a Trigger

   <source lang="sql">

SQL> SQL> DROP TRIGGER yourTriggerName; SQL></source>

If trigger exists, drop trigger

   <source lang="sql">

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