Home Privacy Policy Feedback Link to us Site Map Forums

Oracle/PLSQL: Enable all Triggers on a table


The syntax for a enabling all Triggers on a table is:

ALTER TABLE table_name ENABLE ALL TRIGGERS;


For example:

If you had a table called orders and you wanted to enable all triggers on this table, you could execute the following command:

ALTER TABLE orders ENABLE ALL TRIGGERS;