–
UPDATE更新数据SQL
UPDATE /+append parallel(A,8) nologging/ CRSMAK.M_CM_GS_BILL_DISH_INFO A --票据贴现信息
SET A.YEAR_PAR_AMT =
(SELECT /parallel(B,8)/
YEAR_PAR_AMT
FROM (SELECT BIZ_ID, SUM(NVL(PAR_AMT, 0)) YEAR_PAR_AMT --年累计票面金额
FROM CRSMAK.
–
UPDATE更新数据SQL
UPDATE /+append parallel(A,8) nologging/ CRSMAK.M_CM_GS_BILL_DISH_INFO A --票据贴现信息
SET A.YEAR_PAR_AMT =
(SELECT /parallel(B,8)/
YEAR_PAR_AMT
FROM (SELECT BIZ_ID, SUM(NVL(PAR_AMT, 0)) YEAR_PAR_AMT --年累计票面金额
FROM CRSMAK.