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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT

Re: SELECT

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Mon, 24 Sep 2001 12:56:23 +0000 (UTC)
Message-ID: <511509bcf7195769d73409988fb54cb4.20305@mygate.mailgate.org>


Hi,

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:x%Iq7.7486$JN.23502_at_news1.sttls1.wa.home.com...

> I think this works
> select ... from (select rownum,.... from mytable where
> non_rownum_predicates) where rownum>x and rownum<y;

will not work (you are using the actual rownum in the where-clause) ,however select myrownum, ...
from

                    (select rownum myrownum,... 
                     from mytab where ...)
where myrownum betweeen x and y

will do it.
However, there is no order in RDBMS tables, so the right choice for your problem
should be using of cursors.

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Sep 24 2001 - 07:56:23 CDT

Original text of this message

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