This week's giveaway is in the Groovy forum.
We're giving away four copies of Groovy Fundamentals video training course and have Ken Kousen on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes An entry for pagination queries added to Oracle FAQ Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "An entry for pagination queries added to Oracle FAQ" Watch "An entry for pagination queries added to Oracle FAQ" New topic
Forums: JDBC and Relational Databases Oracle/OAS
Author

An entry for pagination queries added to Oracle FAQ

Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3708
    
  61

Since a question on how to do a pagination query in Oracle pops out every now and then, and doing so correctly in Oracle is far from straightforward, I've added an entry dealing with this subject to our Oracle FAQ here:

http://www.coderanch.com/how-to/java/OracleFaq#paginationquery

If you're interested, please have a look there. It's possible that I've messed something up or missed an important point. Anyone can edit a wiki page, so feel free to edit it right away - or post your feedback here and I'll incorporate it. Thanks.
 
Consider Paul's rocket mass heater.
 
subject: An entry for pagination queries added to Oracle FAQ