Hi,

I have a trigger somthing like:

create .....after update of col1,col2... on table t
---- I want to identify which column is updated:
IF :new.col1 <> :0ld.col1 OR (:new.col1 is null and :0ld.col1 is not null) OR (:new.col1 is not null and :0ld.col1 is null) THEN
do...1;
ELSE
.....
END IF;

My question:

Can I use "IF updating('col1') instead of the long "<> or NUll" things above? I saw them in the docus, but it seems not working for me? Please help.

Thanks

[Edited by mber on 03-21-2001 at 04:25 PM]