HI,
I am writing a trigger to update table b, depending on updates on table a.
table a and b has 300 columns. I want to update only those columns which are changed by update statement like, lets say col is a column in table a
my trigger body will be
UPDATE TRIGGER ON A
OLD AS O
NEW AS N
if ( O.col <> N.co) then
update b set col = some value
end if
...