Re: How to get fixed number of rows from the result of SELECT

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Sep 2002 08:33:48 -0700
Message-ID: <92eeeff0.0209280733.414e2420@posting.google.com>

Sun Guonian <sun_at_cnnic.net.cn> wrote in message news:<3D951EE7.A0B0A883_at_cnnic.net.cn>...
> I have a table with about 1000 records, I want to output
> them to the webpage only 10 records per page by CGI.
> when user click next, he will get the next 10 records.
>
> I could do it by select them all, but it cost too many time.
> I wonder if there some better method to do it with SQL.
>
> Sun Guonian

I have come across this on Tom Kyte's "Ask Tom Kyte" website a while back. He gave a very good code example to do it. Don't have exact link to his example but you can search for it at http://asktom.oracle.com/pls/ask/f?p=4950:1:

/Rauf Sarwar Received on Sat Sep 28 2002 - 10:33:48 CDT