Oracle数据库分页查询sql模板

select * from (

    select rownum rw,i.* from (

        select * from tableName

    ) i

    where rownum <= pageSize*currentPage

) ii

where ii.rw > pageSize*(currentPage-1)