Oracle ENABLE Trigger

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

The ALTER TRIGGER statement is used to enable a trigger.

Syntax

  1. ALTER TRIGGER trigger_name ENABLE;   

Parameters

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

Oracle ENABLE Trigger Example

  1. ALTER TRIGGER SUPPLIERS_T1 ENABLE;   

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

Oracle Enable trigger

Oracle ENABLE ALL Triggers Example

Syntax

  1. ALTER TABLE table_name ENABLE ALL TRIGGERS;  

Example

  1. ALTER TABLE SUPPLIERS ENABLE ALL TRIGGERS;  

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

Oracle Enable trigger 2