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>