To indicate the referencing clause:

  1. From the Choose the Trigger Action Time window of the Create Trigger Wizard click Next. The Create Trigger Advanced Settings window is displayed.

  2. When you create a For each row type trigger,

  3. Enter a substitute name to refer to the old value in the OLD field.

  4. Enter a substitute name to refer to the new value in the NEW field.

  5. Click Next. The Specify a WHEN condition clausewindow will open.


Related topic:

Indicating the Referencing Clause
Entering the WHEN condition clause

To Specify a WHEN condition

To specify trigger action settings