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

Gillian D. Murugappan wrote:
>
> 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?

You may specify that the trigger fire only when certain columns are modified, but the only way to tell specifically which column is being changed is to compare :old.xxx with :new.xxx.

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"