oracle 分页

select * from

 ( 

select t.*,rownum row from

 (

select * from table  where 列名 = ' ' order by  ‘index’, rowid

) t

where row <=?

)

 where  row >=?