Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can a rownum help in implementing Pagination

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

How can we use rownum technique to implement pagination .

My query is that we use rownum to limit the the number of records given by database engine .

Where as the concept of Pagination involves to display results based on the click of the Hyper Link
(Similar to Google Search )

For example if i click on "4" Hyperlink i want to display data from 40th record to 50th record , how a rowmnum can help in this case ??

Please share your ideas .

Thanks in advance .





 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's a journal article for this.
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the link is so helpful .

Thank you very much .

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic