Re: Update mulitple columns

From: Bernd Dormann <Bernd.Dormann_at_lhsystems.com>
Date: Thu, 16 Sep 1999 11:18:21 +0200
Message-ID: <37E0B5DD.AC0623D6@lhsystems.com>

I think you should use just one SET like update testcycl

          set tc_user_01 = :new.rn_user_02,
              tc_user_02 = :new.rn_user_03,
              tc_user_03 = :new.rn_user_03
    where tc_test_id = :new.rn_test_id
        and tc_cycle = :new.rn_cycle;

end;

Bye
Bernd

Chris Forlano wrote:
>
> I'm using Oracle 8.0.5 on Solaris 2.6.
>
> Is there any reason I cannot do the following?
>
> create or replace trigger copy_run
> after insert
> on run for each row
> begin
> update testcycl
> set tc_user_01 = :new.rn_user_02,
> set tc_user_02 = :new.rn_user_03,
> set tc_user_03 = :new.rn_user_03
> where tc_test_id = :new.rn_test_id
> and tc_cycle = :new.rn_cycle;
> end;
>
> The fool thing is giving me compile errors.
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
Received on Thu Sep 16 1999 - 04:18:21 CDT