oracle分页

 

从taba中获取第1到10条记录
select * from ( select row_.*, rownum rownum_ from ( 
        select id,name from table taba
) row_ where rownum <= 10) where rownum_ >= 1)