limit句の代用

select code, name from tablename order by code limit 10, 5

＃mysql でこう書いていたものを、oracle ではこうやって実現する

select
  *
from
  ( select
      rownum rn, t.*
    from
      ( select code, name from tablename order by code ) t ) a
where
  a.rn >= 10 and a.rn < 15;

＃もしくは

select
  rownum, t.*
from
  ( select code, name from tablename order by code ) t
where
  rownum <= 14
minus
select
  rownum, t.*
from
  ( select code, name from tablename order by code ) t
where
  rownum < 10;