Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: To determine which field was update
You can do a comparison using :old and :new.
i.e.
if :old.fld1 != :new.fld2
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 CDT