Re: Update mulitple columns

syntax is:

    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;

Chris Forlano a écrit dans le message <37E02C97.2FBD1CA1_at_nortelnetworks.com>...
>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 - 02:55:17 CDT