oracle分页

select *
  from (select rownum rn, t.* from (select line_id from ccatstep_tbl_lineinfo) t where rownum<=20) x
 where x.rn >= 10