Re: Retrive a set of tuple

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 2000/07/04
Message-ID: <8jt8an$ni8$1@nnrp1.deja.com>#1/1

In article <8jt247$u9t$1_at_le.cs.unibo.it>,   Simone Celli_Marchi <celli_at_cantina.students.cs.unibo.it> wrote:
> Hi,
>
> I looking for a method to retrive a set of tuples from a table. For
 example
> I want to retrive from the 15th to 30th tuple without the need to
 keep in
> memory all tuples e select them from my cgi.
>
> Thank you and sorry for my english.
>
> --
> SysAdm on cantina.students.cs.unibo.it
> Undergraduate student of Computer Science
> http://caristudenti.cs.unibo.it/~celli
> Key fingerprint = D8BD F3D0 00A5 9C96 4A07 DE62 2A4C EDE1 06AA E5BC
>
>

select *
  from ( select rownum r, a.*

           from (YOUR_QUERY_GOES_HERE) a
          where rownum <= :MAX_ROW )

 where r >= :MIN_ROW
/

works in all releases 7.1 and up.

in 8i (8.1) works with all queries -- including those with order by. In 8.0 and before - no order by.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Tue Jul 04 2000 - 00:00:00 CDT