Oracle数据库分页

/**
*查询分页
*page:3
*pageSize:10
*/
--分页公式
SELECT *
  FROM 表
 WHERE ROWID IN
       (SELECT RID
          FROM (SELECT ROWNUM RN, RID
                  FROM (SELECT ROWID RID, 主键字段 from 表)
                 WHERE ROWNUM <= ((page - 1) * pageSize + pageSize)) --每页显示几条
         WHERE RN > ((page - 1) * pageSize)) --当前页数
 ORDER BY 主键字段;
 --实际操作
SELECT *
  FROM student
 WHERE ROWID IN
       (SELECT RID
          FROM (SELECT ROWNUM RN, RID
                  FROM (SELECT ROWID RID, xh from student)
                 WHERE ROWNUM <= ((2 - 1) * 6 + 6)) --每页显示几条
         WHERE RN > ((2 - 1) * 6)) --当前页数
 ORDER BY xh;