Re: PL/SQL: To determine which field was update

[Quoted] [Quoted]  You can do a comparison using :old and :new. i.e.
if :old.fld1 != :new.fld2

• do something since the field is updated endif

Gillian D. Murugappan wrote in article <33E8AB15.7BF7_at_amoco.com>...

>I have to write a trigger to update a second table when any field in the
>first table was updated.
>
>I would not be updating the table but the enduser. How do I determine
>which field in the first table was updated?
>
>Does Oracle have some reserved word that I can track the field updated
>in a particular row?
>
>This is urgent.
>Thanks for the help
>Gillian
Received on Wed Aug 06 1997 - 00:00:00 CEST