The ALTER TRIGGER statement is used to enable a trigger.

Syntax

ALTER TRIGGER trigger_name ENABLE;   

Parameters

trigger_name: It specifies the name of the trigger that you want to enable.

Oracle ENABLE Trigger Example

ALTER TRIGGER SUPPLIERS_T1 ENABLE;   

This example will enable the trigger named "SUPPLIERS_T1" in the "SUPPLIERS" table.