|
LOOP
UPDATE 得意先集計
set
更新日 = SYSDATE
,当月売上金額 = 当月売上金額 + FLD_金額
where
請求先 = FLD_取引先
and 経過月 = EXTRACT(month from FLD_日付)
;
IF SQL%NOTFOUND THEN
INSERT INTO 得意先集計
(請求先,経過月,当月売上金額,更新日)
VALUES(FLD_取引先,EXTRACT(month from FLD_日付),0,SYSDATE);
ELSE
EXIT;
END IF;
END LOOP;
| |