CREATE OR REPLACE PROCEDURE sp_Page
(
whichPage IN INT DEFAULT NULL,
PageSize IN INT DEFAULT NULL,
RsCount IN OUT INT,
pageCount IN OUT INT
)
AS
BEGIN
SELECT COUNT(*) INTO sp_Page.RsCount
FROM myTable;
pageCount := RsCount / PageSize;
SELECT *
FROM
(SELECT *
FROM
(SELECT *
FROM myTable
ORDER BY ID DESC)
WHERE ROWNUM<=PAGESZIE*WhichPage)
WHERE ROWNUM<=PageSize;
END;
/
(
whichPage IN INT DEFAULT NULL,
PageSize IN INT DEFAULT NULL,
RsCount IN OUT INT,
pageCount IN OUT INT
)
AS
BEGIN
SELECT COUNT(*) INTO sp_Page.RsCount
FROM myTable;
pageCount := RsCount / PageSize;
SELECT *
FROM
(SELECT *
FROM
(SELECT *
FROM myTable
ORDER BY ID DESC)
WHERE ROWNUM<=PAGESZIE*WhichPage)
WHERE ROWNUM<=PageSize;
END;
/
解决方案 »
- 【虚心求教】6年SQL SERVER经验如何快速学习ORACLE?
- 批量插入的多个select怎么写
- oracle 中关于 group by all
- 求救:ORACLE 中用sql进行分页在两个数据库中结果不一样!
- 请问如何改变已有记录的表的字段名称呢?
- Oracle9i的安装问题,,急死了。。。
- 请问各位大虾在oracle中怎么实现下面这个语句,急,在线等待
- 我是一个oracle初学者,安装了oracle服务器版后,却看不到数据库中的表,用toad却能看到...
- 带参数的动态行转不定列,求大神指导
- 10W级别数据校验,想用函数去执行校验并且返回一条自定义的记录
- 如何通过SQL语句一次Create多个触发器?
- 这样的存储过程怎么写?(含有脚本)
(
whichPage IN INT,
pageSize IN INT,
rsCount IN OUT INT,
pageCount OUT INT
)
AS
BEGIN
(
SELECT COUNT(*) INTO rsCount FROM myTable;
pageCount := rsCount / pageSize;
SELECT * FORM(SELECT * FROM(SELECT * FROM myTable ORDER BY ID DESC) WHERE ROWNUM<=pageSize*whichPage) WHERE ROWNUM<=pageSize;
END;
/