Re: UPDATE

From: Maria Quinn <maria_at_foremost.co.uk>
Date: Wed, 23 Oct 2002 02:18:27 -0800
Message-ID: <F001.004F0C04.20021023021827@fatcity.com>

I got it working using a correlated subquery like this:

update x a
set a.id2 = (

     select b.id2
     from x b
     where b.id2 <> 0
     and b.id1 = a.id1

)
where a.id2 = 0;

Maria

At 01:33 23/10/02 -0800, you wrote:
>Hi,
>
>I have table x with 2 columns:
>
>ID1 ID2
>---- ----
>1 0
>1 5
>2 0
>2 10
>
>I want to update ID2, set the 0s to the other value
>for the same ID1. So, i would have:
>
>ID1 ID2
>---- ----
>1 5
>1 5
>2 10
>2 10
>
>Whats the best way to do this?
>
>Thanks.
>
>__________________________________________________
>Do you Yahoo!?
>Y! Web Hosting - Let the expert host your web site
>http://webhosting.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Imran Ashraf
> INET: imran9a_at_yahoo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Quinn
  INET: maria_at_foremost.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 23 2002 - 05:18:27 CDT