Pages

Friday, 29 November 2013

What are triggering attributes?



Answer
Triggers can be fired based on the following criteria:

Category - (INSERT, DELETE, UPDATE) i.e. which kind of DML statement causes the trigger to fire.

Timing – (BEFORE or AFTER) i.e. whether the trigger fires before the statement is executed of after.

Level – (Row or Statement) i.e. whether it fires once for each row affected by trigger statement or whether it fires once.

No comments:

Post a Comment

Enter Your Question

Total Pageviews

Blog