Re: returning rows between two positions in a large query

You could try selecting the result set into a PL/SQL array (with Oracle 8 you can use an array fetch) as part of a packaged procedure, then the return set to the end user could be specified by the array bounds you want to show (with 8.1 you can shift part of the array into an object type and cast it into a cursor).

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Y2K wrote in message <376f8518.248375575_at_news.concentric.net>...
>I have a large select query that returns rows from a table in
>different sort orders depending on user inputs, and I wonder if there
>is any way to return just the rows between two specified positions?
>
>For example, let's say the query returns 2000 rows (in different
>orders depending on user input), and I only want 50 rows from #150 to
>#199.
>
>An analogy would be when you go to yahoo and do a search, and the
>results are broken down into various pages. I want to do the same
>thing in my web app.
>
>TIA!
Received on Tue Jun 22 1999 - 13:27:15 CDT