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?