I executed Database Trigger execution order example given in HOW TO's for update statement.


Before update on table and After update on table are executed irrespective of whether update statement updates rows or not?

What is the use of firing these two triggers eventhough not even a single row effected? When do we use these two triggers?

If there is no update statment then the trigger is not going to fire.

Trigger Execution Orders are different according to the Trigger u r using.
There are two types of Triggers generaly used.
1. Application Triggers
2.Database trigger.

Each type of trigger (say application trigger or Database trigger)having different execution order.Pls leave message which trigger u r using..