Oracle的翻頁Sql語句

　　StringBuffer pagingSelect = newStringBuffer();

        pagingSelectappend(select * from ( select row_* rownum rownum_ from ( );
        pagingSelectappend(sql);
        pagingSelectappend( ) row_ where rownum <= + endRow + ) where rownum_ > + startRow);

startRow 是記錄開始處
endRow 是記錄結束處

舉例來說
從第條到第條

select * from (

　　select row_* rownum rownum_from (
      
            select person_id chn_name chn_firstname_py from t_pbase_info
          
        ) row_ where rownum <=
      
    ) where rownum_ >=

From:http://tw.wingwit.com/Article/program/Oracle/201311/17173.html