oracle 分页模板

SELECT *
FROM (SELECT ROW_.*, ROWNUM ROWNUM_
FROM (
select * from table
) ROW_
WHERE ROWNUM <= v_curPage * v_pageSize)
WHERE ROWNUM_ > (v_curPage - 1) * v_pageSize

posted @ 2016-08-01 17:39  木子小三  阅读(106)  评论(0编辑  收藏  举报