neeraj06.in

 Profile Answers by neeraj06.in 

• Nov 10th, 2011

 

Compound Triggers:
-> It combines all DML timing events into single trigger body.
-> It also resolves mutating table error and enhance the code maintenance.
-> The memory variables are persistent till execution finishes.

Example:

Code
CREATE OR REPLACE TRIGGER [TRIGGER NAME]


FOR [DML] ON [TABLE NAME]


COMPOUND TRIGGER


-- Initial section


-- Declarations


-- Subprograms


Optional section


BEFORE STATEMENT IS


…;


Optional section


AFTER STATEMENT IS


…;


Optional section


BEFORE EACH ROW IS


…;


Optional section


AFTER EACH ROW IS


…;


END;


 

For views, the trigger body contains INSTEAD OF EACH ROW section.