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
span style="font-style: italic;">-- Initial section


-- Declarations


-- Subprograms

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