Comment by fendale

Oracle does seems to make limit queries much harder than they need to be. I wrote an article about limit and paging queries in oracle ages ago that may interest you, but you probably have it all figured out now.

http://betteratoracle.com/posts/18-limiting-query-results-to...