Re: Q: returning rows between two positions in a large query

From: Slawek L. <slisznianski_at_cucentral-ab.com>
Date: Thu, 22 Jul 1999 11:17:44 -0600
Message-ID: <7n7jsp$oan$1@iceman.tac.net>

Could you please be more specific as to how you would solve the problem? There are two things to remember 1) under Oracle the subquery is not allowed to have an ORDER BY clause and 2) rownum reflects row numbers before they were sorted.

Thanks,
Slawek

In article <3771e55d.0_at_145.227.194.253>, "Mark G" <mgumbs_at_nospam.hotmail.com> wrote:
> No.
>
> You create ONE temp table (or PL/SQL table) with all your data (700
records
> for example), sort the data in your prefered order and use the rownum
method
> to obtain your row range. You use the same table when going from one page
> to another.
>
> Mark
>
> Y2K wrote in message <37710965.69216087_at_news.concentric.net>...
> >Good suggestion. I still have a concern on performance. How big
> >would the overhead be of creating temp tables each time a user goes
> >from one page of 50 records to another one? Would it scale to a large
> >number of users? I am new to Oracle, so pardon my naive questions.
> >
> >Thanks!
> >
>
>
Received on Thu Jul 22 1999 - 12:17:44 CDT