ENABLE TRIGGER in Oracle

ORACLE ENABLE TRIGGER
As the name itself suggests, this type of trigger is used to ENABLE an already existing or newly created trigger for a table from the database. To serve this purpose ALTER TRIGGER statement is used.

Syntax:

ALTER TRIGGER trigger_name ENABLE;     

Parameters:
trigger_name: It is used to specify the name of the trigger to be created.
Example:

Students Table:

Create Trigger code:

CREATE OR REPLACE TRIGGER  "STUDENTS_T"   
AFTER INSERT or UPDATE or DELETE    
ON "STUDENTS"   
FOR EACH ROW
BEGIN  
WHEN the person performs insert/update/delete operations into the table.  
END;  
/  
ALTER TRIGGER  "STUDENTS_T" ENABLE  
/

Output:

TRIGGER NAME	TRIGGER TYPE	TRIGGERING EVENT	       STATUS
STUDENTS_T	AFTER EACH ROW	   INSERT or UPDATE or DELETE	     ENABLED

Explanation:
The ‘students’ is an already existing table and a trigger is created with the name “STUDENTS_T”. AFTER the INSERT, UPDATE or DELETE statement is issued on the table “STUDENTS”, the Oracle database will fire the trigger, since it is in the ENABLED mode.

Alex Martin