| 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))
![]() |
![]() |