oracle 分页

select *
  from (select b.*,rownum a from (select * from 表名) b)
 where a between 5 and 10;