Home Privacy Policy Feedback Link to us Site Map Forums

Oracle/PLSQL: Disable a Trigger


The syntax for a disabling a Trigger is:

ALTER TRIGGER trigger_name DISABLE;


For example:

If you had a trigger called orders_before_insert, you could disable it with the following command:

ALTER TRIGGER orders_before_insert DISABLE;