Xref: alice comp.databases.oracle.misc:34225 comp.databases.oracle.server:54346 Path: alice!news-feed.fnsi.net!news.idt.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: returning rows between two positions in a large query Date: Tue, 22 Jun 1999 19:27:15 +0100 Message-ID: <930076515.3325.0.nnrp-04.9e984b29@news.demon.co.uk> References: <376f8518.248375575@news.concentric.net> X-Trace: news.demon.co.uk 930076515 nnrp-04:3325 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 29 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@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!