Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT
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.ORGReceived on Mon Sep 24 2001 - 07:56:23 CDT