oracle分页

 select *
   from (select A.*, rownum RN
           from (需要查询结果的复杂sql 语句) A
          where rownum <= 结束记录)
  where RN >= 开始记录