Application Development Guide

Set of Affected Rows

A trigger event defines a set of rows in the subject table that is affected by that SQL operation. For example, suppose you run the following UPDATE statement on the parts table:

    UPDATE PARTS 
      SET ON_HAND = ON_HAND + 100 
      WHERE  PART_NO > 15000

The set of affected rows for the associated trigger contains all the rows in the parts table whose part_no is greater than 15 000.