Re: Paging -- need help with "next 10 results" imple mentation

Hi 

Try this it works for me

select a from (select rownum therow,a from a order by a asc)
where therow between 1 and 10

Chris Sol


> -----Original Message-----
> From:	Bronwyn Hill [SMTP:[email protected]]
> Sent:	16 January 2003 08:08
> To:	Oracle
> Subject:	[oracle] Re: Paging -- need help with "next 10 results"
> implementation
> 
> Hi Adam, 
> 
> Did you ever find a solution to this ? I have not been able to find any 
> solution to this problem .... I really need your help if you ever found 
> any info ... I Have exactly the same problem 
> 
> Thanks a stack 
> Bronwyn 
> 
> > Hi,
> > I'm looking for guidance on how to implement paging using Oracle, and
> > haven't found anything.
> > 
> > Specifically, I'm referring to the presentation of data to a user a 
> little
> > at a time, that is, in "pages".
> > This is quite common on internet search engines, where a user might
> > successfully match 5000 rows of data, but want to view only 20 rows at a
> > time.  It would be quite inefficient for the database server to return 
> all
> > 5000 rows on each user request, and let the app server choose and return
> > the 20 rows that the user wants to see.  Yet this approach is what I
> > see my fellow developers using.  
> > 
> > I've seen at least two approaches to paging for SQLServer, both using 
> temp
> > tables, which are trivial to create in SQLServer.
> > 
> > I've yet to see even a single article on how to implement this Oracle.
> > 
> > I imagine that at least one of the big search engines uses Oracle on the
> > back end.
> > How do they implement paging?  Can anyone give me an authoritative
> answer
> > on this?  It would be greatly appreciated.
> > 
> > Thanks,
> > Adam
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or 
> to unsubscribe send a blank email to %%email.unsub%%.
>  
****************************************************************************
The Genesis Housing Group - Email Disclaimer
--------------------------------------------
The information in this email and any attachments is strictly
confidential and may be legally privileged.
It is intended solely for the use of the addressee(s) only. Access to
this email by anyone else is unauthorised.  If you have received this
email in error please notify the sender immediately by return email or
telephone.  Please note that if you are not the intended recipient, you
must not copy, distribute or otherwise act on any part of this email or
it's attachments.
Although we have taken precautions to ensure that this email and
attachments are free from any virus, we would advise you that it is your
responsibility to ensure that this is true when reading or actioning
this email.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].