17,086
社区成员
发帖
与我相关
我的任务
分享
select sum(smoney) into sumsall
from salary where usid=sid
and sdate>to_date(vdate,'YYYY-MM-DD') and sdate<add_months(vv_date,-12)
-- TRY IT .. 好像是逗号问题 '||date2||', and sdate
CREATE OR REPLACE PROCEDURE SUMSALARY(SID NUMBER,
VDATE VARCHAR2,
SUMSALL OUT NUMBER) AS
V_SQL VARCHAR2(200);
BEGIN
V_SQL := 'SELECT SUM(SMONEY) FROM SALARY WHERE USID=' || SID ||' AND SDATE>ADD_MONTHS(TO_DATE('||VDATE||', ''YYYY-MM-DD''), -12) AND SDATE <= TO_DATE('||VDATE||', ''YYYY-MM-DD'')';
EXECUTE IMMEDIATE V_SQL INTO SUMSALL;
END;
[Quote=引用楼主 zhangsq 的帖子:]