Re: RE: ROWNUM - Can the inner-outer idea be extended to an update?

next tested it but id guess. dont know about 8i. why would you want to do that? if you post what your goal is, ther emay be a better method.

   UPDATE EMP2
   SET GENDER = 'F'
   WHERE GENDER = (Select gender.(nested stuff) here. same as from that link.  

>
> From: MaryAnn Atkinson <[EMAIL PROTECTED]>
> Date: 2003/07/09 Wed PM 01:34:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ROWNUM - Can the inner-outer idea be extended to an update?
>
> Can the inner-outer idea be extended to an update?
>
> UPDATE EMP2
> SET GENDER = 'F'
> WHERE GENDER = ' '
> AND ROWNUM BETWEEN 10 AND 20;
>
>
> That does NOT work, because as we explained the returned rows
> are numbered starting from 1, and so rownum never really matches
> a 10 or 20 or anything in between.
>
> Thanks,
> maa
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MaryAnn Atkinson
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).