Re: Paging -- need help with "next 10 results" implementation

Hi, 

If anyone is interested - I found a solution :

http://www.faqts.com/knowledge_base/view.phtml/aid/16331/fid/148

Ciao 
Bron 


> Hi Adam, 

> Did you ever find a solution to this ? I have not been able to find any 
s> olution to this problem .... I really need your help if you ever found 
a> ny info ... I Have exactly the same problem 

> Thanks a stack 
B> ronwyn 

> > 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 
l> ittle
>>  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 
a> ll
>>  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 
t> emp
>>  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].