Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can you use a decode with the SET clause of UPDATE statement
"Roy Munson" <mtproc_at_yahoo.co.uk> a écrit dans le message de
news:853055e7.0408020558.33b4712e_at_posting.google.com...
> Each,
>
> Can you use a decode like so....
>
> update table
> set decode(field_a, value_1, field_b, field_c) = value_2;
>
> Compiler says not....wanting to update either field_b or field_c
> depending on the value of field_a.
>
> What say you?
>
> TIA
>
> Roy
Something like:
update table set
field_b=decode(field_a,value_1,value_2,field_b),
field_c=decode(field_a,value_1,field_c,value_2)
/
-- Regards Michel CadotReceived on Mon Aug 02 2004 - 09:05:46 CDT