Re: Oracle Queries/Paging

From: Stephen Pillow <stephenpillow_at_yahoo.com>
Date: Tue, 19 Oct 1999 11:01:50 -0500
Message-ID: <1C0P3.1630$l05.41547@typ11a.deja.bcandid.com>

You can look at the thread with the subject "insert statement using order by". Look at the one sent by Thomas Kyte.

Essentially, you can do it using nested queries. However, this only works in 8i.

Example:

scott_at_8i> select * from
  2 ( select rownum r, a.* from ( select ename, job, sal

  3                                    from emp
  4                                   order by ename, job, sal ) a
  5       where rownum <= 10 )

  6 where r >= 5

<mlecza_at_my-deja.com> wrote in message news:7u2fl3$15j$1_at_nnrp1.deja.com...
> Has anyone come up with a scalable solution to handle paging large
> queries? For example, if I have a web page that return a recordset of
> 2000 record - I do not want to display all 2000 records on one page.
>
> It would also be nice if I did not have to run the same query (that
> comes back with 2000 records) each time they went to the next page.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 19 1999 - 11:01:50 CDT