Oracle PL/SQL Tutorial/Trigger/Drop Trigger

Dropping a Trigger

SQL>
SQL> DROP TRIGGER yourTriggerName;
SQL>

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>