oracle 페이지당 10개씩 게시물 확인

select *
from(
    select rownum rnum, e.*
    from (select * from emp doder by ename) e
    order by e.ename;
) ee
where ee.rnum between 1 and 10;