Home Privacy Policy Feedback Link to us Site Map Forums

Oracle/PLSQL: Enable a Trigger


The syntax for a enabling a Trigger is:

ALTER TRIGGER trigger_name ENABLE;


For example:

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

ALTER TRIGGER orders_before_insert ENABLE;