Re: Selecting a range of records

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Sat, 21 Jul 2001 21:28:47 GMT
Message-ID: <994327577.12984.0.nnrp-12.c30bdde2@news.demon.co.uk>

select * from
(

select rownum r,table_name from user_Tables )
where r > 32 and r < 115

Be aware that you will execute the entire subquery just to return your sub-range afterwards so it could get very expensive.

<jabelsc_at_yahoo.com> wrote in message
news:3b442c77.179827625_at_news.ericsson.se...
>
> Hello everybody!
>
> I want to make a select of a table with a great amount of
> records and I only want to select only a range of them, for example,
> records between number 32 and 112.
>
> Is it posible to include a range in a select query in Oracle?
> I've heard that it's possible in Informix, I think.
>
> What I want to do with it is decrease the traffic between
> Oracle and a JSP application we have in different servers.
>
> Thanks.
>
> Abel S.
Received on Sat Jul 21 2001 - 16:28:47 CDT