/*
@author:ly
@date:20081208
@desc:传表名,栏位名,获取表该栏位的最大值
*/
PROCEDURE P_GETMAXID
(
V_TABLE VARCHAR2,
V_FILEID VARCHAR2,
O_MAX OUT NUMBER
)
AS
V_SQL VARCHAR2(500);
BEGIN
V_SQL:='SELECT NVL(MAX('||V_FILEID||'),1) FROM '||V_TABLE;
EXECUTE IMMEDIATE V_SQL INTO O_MAX;
END;
@author:ly
@date:20081208
@desc:传表名,栏位名,获取表该栏位的最大值
*/
PROCEDURE P_GETMAXID
(
V_TABLE VARCHAR2,
V_FILEID VARCHAR2,
O_MAX OUT NUMBER
)
AS
V_SQL VARCHAR2(500);
BEGIN
V_SQL:='SELECT NVL(MAX('||V_FILEID||'),1) FROM '||V_TABLE;
EXECUTE IMMEDIATE V_SQL INTO O_MAX;
END;