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

see asktom.oracle.com:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1881114::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:76812348057,%7Bpaging%7D

-----Original Message-----
From: Bronwyn Hill [mailto:[email protected]]
Sent: Thursday, January 16, 2003 3:08 AM
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%%.


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