Re: Q: Evaluation of :old in triggers

Hi Ivan,

you may want to write a separate trigger for each update. Then only that trigger fires whose column is updated. You specify

create or replace trigger ...
after update of col1
on tab
...

create or replace trigger ...
after update of col2
on tab
...

Martin Received on Wed Apr 18 2001 - 16:28:26 CDT