-
Hi,
I saw in docus: to identify which column is updted in the "after update of col1, col2,.... on table t" database trigger, you can use:
IF updating('col1') then
do_1
ELSIF updating('col2') then
do_others
end if;
Is this true? Or we have to use:
If :new.col1 <> :0ld.col1 OR (:new.col1 is null and :0ld.....).
Please help.
Thanks
-
Did you test either theory?
- Magnus
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|