本文介绍了两个PL/SQL函数：USF_CALC_ROW_START和USF_CALC_ROW_END，用于计算分页查询中每页记录的开始和结束编号。这两个函数接受页面编号和每页记录数作为参数，并返回对应的起始和结束记录位置。
CREATE OR REPLACE FUNCTION "USF_CALC_ROW_START"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN ((PG_NUM_IN - 1) * TOTAL_REC_PER_PG_IN) + 1;
END;
CREATE OR REPLACE FUNCTION "USF_CALC_ROW_END"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN (PG_NUM_IN * TOTAL_REC_PER_PG_IN) + 1;
END;
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN ((PG_NUM_IN - 1) * TOTAL_REC_PER_PG_IN) + 1;
END;
CREATE OR REPLACE FUNCTION "USF_CALC_ROW_END"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN (PG_NUM_IN * TOTAL_REC_PER_PG_IN) + 1;
END;
扫一扫
169
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
