http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:25685777038588
in general your query won't get the "next n rows".

Why would you not just:


select /*+ FIRST_ROWS */ *
  from ( select /*+ FIRST_ROWS */ a.*, rownum rnum
           from (select /*+ FIRST_ROWS */ * from t where .... order by ... ) a
          where rownum <= :MAX_ROW )
 where rnum >= :MIN_ROW;


done.  that is how I write all pagination queries.


(you do know that A||B has serious programming issues -- A=1, B=11 vs A=11, B=1 
-- you need to encode the fields very very carefully.  don't go there, really 
bad, confusing idea.
[@more@]
ITPub博客

how tom write pagenation sql

最新文章
