Pagination - Limiting search results

[Prince26]

I have been searching high and low for the query statement to return a certain row in a result set. I have 10000 records in my result set. I want to retrieve only 50 of them at a time for my pagination. Once I am done, I want to retrieve the next 50 and so forward. Is there a simple and direct method to do that?

 

[johnherman]

simple and direct? how about a cursor?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[Prince26]

Thanks for the response..

I was reading blogs on cursors last week and it was mentioned to use scrollable cursors but had no idea how do i implement it for pagination...

 

[johnherman]

You will need a local array storage element to store 50 at a time. Fetch records until your counter reaches 50 or you hit end of set (no more rows) code. When you are ready, re-execute the procedure to populate 50 rows.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[Prince26]

Thanks alot for the idea.