PL/SQL Trigger

Trigger is fired when DML statement is executed.

Time :	BEFORE	AFTER	INSTEAD OF
Event :	INSERT	UPDATE	DELETE

The Syntax for creating a trigger is:

CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE | AFTER | INSTEAD OF} {INSERT [OR] | UPDATE [OR] | DELETE} [OF col_name] ON table_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] WHEN (condition) BEGIN     --- sql statements END;

 

References :

• http://www.plsql-tutorial.com/