Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How can I do it optimally ?
How can I do it optimally ?
update Tab1
set Tab1.field2=(
select sum (decode (field1,1,field2,0)+decode (field1,2,field3,0)) from Tab1 where field1 in (1,2))