Oracle: Paging Results
February 5th, 2010
Comments off
Paging Oracle developers…
This will be a quick post, as the problem is small. I will add, though, that setting up paging with database queries can be a major pain in the ass. Setting up the consumer – usually jQuery, ExtJS, DWR, or some other AJAX client, is hard enough, but then you have to translate the client’s version of “start-limit” to the persistance-side’s language. Sometimes it’s a simple start/limit pair, sometimes it’s a start/page pair, and then there’s Oracle, which decided to punt on the whole thing. Read more…