Re: After UPDATE Trigger code

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 23 Mar 2000 09:09:24 -0500
Message-ID: <bb9kds8vgn6qqun2h3piu4hja77ivdml86@4ax.com>

A copy of this was sent to "Nicky Taylor" <nicky.taylor_at_gecm.com> (if that email address didn't require changing) On Thu, 23 Mar 2000 11:11:45 -0000, you wrote:

>Please Help!
>
>Can someone tell me how you reference the columns for the row you are
>currently updating in an After-Update Trigger?
>
>I know that in a Before-Insert Trigger you use the notation
>:NEW.column_name, I was just wondering how to do the same with an update on
>that row?
>
>TIA,
>
>N Taylor
>

In an "AFTER UPDATE FOR EACH ROW" trigger you have read access to the :new and :old records.

In a "BEFORE UPDATE FOR EACH ROW" trigger you have read/write access to the :new and :old records.

--
http://osi.oracle.com/~tkyte/

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Mar 23 2000 - 08:09:24 CST