Skip to Main Content
  • Questions
  • How to return result of a query in chunks of 100 rows at a time.


Question and Answer

Connor McDonald

Thanks for the question, Shreem.

Asked: February 02, 2009 - 12:47 pm UTC

Last updated: November 18, 2021 - 3:02 am UTC

Version: 9.2.0

Viewed 1000+ times

You Asked

Hi Tom,

I have a requirement where in users want that on the screen where we display result set of a query only 100 rows should be displayed at a time and again when user clicks button ( on the screen named Next) next 100 rows should be displayed from the query result and so on till result ends.

Can I handle this scenario in a PLSQL/SQL?

Many thanks to you for providing such a interface to us.


and Tom said...


  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment


A reader, November 17, 2021 - 12:06 pm UTC

Both links are wrong now.
Connor McDonald
November 18, 2021 - 3:02 am UTC

Sorry, we don't have control over the magazine article links on the oracle blog site :-( We've asked numerous times for restoration of links to no avail

I think the articles now correct as per an archive I took of the blog site a while back

More to Explore


The Oracle documentation contains a complete SQL reference.