oracle分页查询

oracle分页查询：

第1页，每页10条数据

select * from (select rownum rn,x.* from (select * from customer) x where rownum<=1*10) where rn > (1-1)*10;

第2页

select * from (select rownum rn,x.* from (select * from customer) x where rownum<=2*10) where rn > (2-1)*10;