select /* + ordered use_nl(tt,t) */
t.*
from (select *
from (select rownum rn, a.rid
from (select rowid rid
from tableName
where condition) a
where rownum <= #endRow#)
where rn >= #startRow#) tt,
tableName t
where tt.rid = t.rowid
另外一种简单的分页模板
select *
from (select a.*, rownum rn
from (select t.*
from tablename t
where condition) a
where rownum <= #endRow#)
where rn >= #startRow#