取第10行到100行

select * from   
(  
select a.*,rownum rn from   
(  
select  a.*  
  from dba_objects a   
 order by object_id   
) a  
where rownum<=100 
) where rn>=11;