Home » SQL & PL/SQL » SQL & PL/SQL » Recordset Paging Example
Recordset Paging Example [message #196491] Thu, 05 October 2006 10:31 Go to next message
bcolflesh
Messages: 3
Registered: October 2006
Junior Member
Can someone post or point me towards an example of recordset paging in PL/SQL? For example, Say I have 100 records - I'd like to display 10 at a time, then have the paging script show a line with a list that will hyperlink to the next set of records chosen, ie:

1-10 | 11-20 | 21-30 | 31-40 | etc...
Re: Recordset Paging Example [message #196494 is a reply to message #196491] Thu, 05 October 2006 10:44 Go to previous messageGo to next message
rigatonip
Messages: 50
Registered: December 2005
Member
Here's link that will in general show you how to get the recordset into groups. You'll need to handle setting the links to pull the ones you want.

http://asktom.oracle.com/pls/ask/f?p=4950:8:6227077744117697976::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:127412348064
Re: Recordset Paging Example [message #196495 is a reply to message #196491] Thu, 05 October 2006 10:50 Go to previous message
bcolflesh
Messages: 3
Registered: October 2006
Junior Member
Thank you for that!
Previous Topic: PREVIOUS YEARS
Next Topic: Date Format
Goto Forum:
  


Current Time: Tue Dec 06 04:43:20 CST 2016

Total time taken to generate the page: 0.25252 seconds