Oracle Topics

Oracle ENABLE Trigger
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.


Oracle ENABLE ALL Triggers Example
Syntax:- 
  

 ALTER TABLE table_name ENABLE ALL TRIGGERS;


Example:- 
  

    ALTER TABLE SUPPLIERS ENABLE ALL TRIGGERS;


This example will enable all the triggers on the table name "SUPPLIERS".