Re: triggers
From: <gsalem_at_fr.oracle.com>
Date: 1995/10/19
Message-ID: <465hkb$oul_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1995/10/19
Message-ID: <465hkb$oul_at_inet-nntp-gw-1.us.oracle.com>#1/1
mcgredo_at_crl.com (Donald R. McGregor) wrote:
>create trigger pr_trig_1
>after update on pr_0_1
>for each row
>begin
>if updating then
>update pr_0_5
>set t1.custName = :new.custName, t1.custAddress = :new.custAddress
>from pr_0_5 t1, pr_0_1 t2
>where t1.custID = t2.custID;
>end if;
>end pr_trig_1;
the update statement should be like this:
update pr_0_5 t1
set custName=:new.custName, custaddress=:new.custAddress
where t1.custId=:new.custId;
Received on Thu Oct 19 1995 - 00:00:00 CET