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;