Hi, Jeff,

You are the right person, please check if it is correct:

Quote:
===============
Oracle8 i
Application Developer’s Guide - Fundamentals
Release 2 (8.1.6)
December 1999
Part No. A76939-01
---------------------- Page 500

In an UPDATE trigger, a column name can be specified with an UPDATING conditional predicate to determine if the named column is being updated. For example, assume a trigger is defined as the following:
CREATE OR REPLACE TRIGGER . . .
. . . UPDATE OF Sal, Comm ON Emp_tab . . .
BEGIN
. . . IF UPDATING (’SAL’) THEN . . . END IF;
END;

The code in the THEN clause runs only if the triggering UPDATE statement updates
the SAL column. The following statement fires the above trigger and causes the
UPDATING (sal) conditional predicate to evaluate to TRUE:
UPDATE Emp_tab SET Sal = Sal + 100;
===============================
Quote end.

I tested it by this way, but it doesn't work.

Please help

Thanks