Oracle Data Source marki  2011-06-21 16:58
Status: Closed
 
This seems to be the accepted way to do LIMIT & OFFSET:

http://stackoverflow.com/questions/241622/paging-with-oracle

It might be possible to use this technique in your dialect limitRows implementation.