Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I do it optimally ?

How can I do it optimally ?

From: <luba_at_usb>
Date: Fri, 19 Jan 2001 11:21:01 +0200
Message-ID: <949f06$1rt$1@news.ukrsotsbank.com>

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))

where field1=1 ; Received on Fri Jan 19 2001 - 03:21:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US