Re: PL/SQL: To determine which field was update
From: Tomm Carr <tommcatt_at_geocities.com>
Date: 1997/08/06
Message-ID: <33E89C86.51A_at_geocities.com>#1/1
Date: 1997/08/06
Message-ID: <33E89C86.51A_at_geocities.com>#1/1
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?
[Quoted] 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!"Received on Wed Aug 06 1997 - 00:00:00 CEST