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 protected].