| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I do it optimally ?
In article <949c74$1ng$1_at_news.ukrsotsbank.com>,
"luba_at_usb" <luba_at_usb.ua> wrote:
> 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 ;
>
Looks like it is optimal. Is it working too long?
>
Sent via Deja.com
http://www.deja.com/
Received on Sun Jan 21 2001 - 21:01:51 CST
 |
 |