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
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.
[Edited by mber on 03-21-2001 at 04:25 PM]
Click Here to Expand Forum to Full Width