Limit results from a query, and selective results.

[Shestakov]

Not optimal, but should work:

select isql.*
from
(select tb.*, rownum rn
from TABLE_NAME tb
) isql
where isql.rn between BEGIN_ROW and END_ROW;