PL/SQL Enable all Trigger

Sometimes you might found that you have disabled all trigger on a table and you wish to enable the triggers back again. In PL/SQL you can enable all the triggers on a table using ALTER TRIGGER statement.

PL/SQL Enable all Trigger Syntax

ALTER TABLE table_name ENABLE ALL TRIGGERS; 

Where:

table_name: The table name that all triggers should be disabled on.

ALTER TABLE tblCustomerLoan ENABLE ALL TRIGGERS;