Re: Trigger and correlation names
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/03/13
Message-ID: <4i6m5e$jso_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/03/13
Message-ID: <4i6m5e$jso_at_bytor.lerc.nasa.gov>#1/1
In article <314544BE.58B3_at_subito.de>, Andreas <andreas_at_subito.de> wrote:
>A new column-value can referenziered with :new.columnname in a trigger.
>When i have a column-string, how i can become the new column-value?
>
>Thank you very much.
Are you asking whether you can do
scalar_variable := :new.column_name;
or
:new.column_name := scalar_variable;
?. In general, the :old and :new values can be manipulated within the trigger.
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: Gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Wed Mar 13 1996 - 00:00:00 CET