Hi I want to use Merge on fairly large tables. Please see my Merge statement
MERGE INTO T1 MST
USING (SELECT CUST_CODE,PGM_CODE,DAILY_AMOUNT FROM T2) TEMP
ON (MST.CUST_CODE = TEMP.CUST_CODE AND MST.PGM_CODE = TEMP.PGM_CODE)
WHEN MATCHED THEN
UPDATE SET
MST.DAILY_AMOUNT = TEMP.DAILY_AMOUNT
MST.MTD-AMOUNT = MST.MTD-AMOUNT + TEMP.DAILY_AMOUNT
MST.YTD-AMOUNT = MST.YTD-AMOUNT + TEMP.DAILY_AMOUNT
WHEN NOT MATCHED THEN
INSERT
(CUST_CODE, PGM_CODE, DAILY_AMOUNT, MTD_AMOUNT, YTD_AMOUNT)
VALUES (TEMP.CUST_CODE, TEMP.PGM_CODE, TEMP.DAILY_AMOUNT, TEMP.DAILY_AMOUNT, TEMP.DAILY_AMOUNT)
I never used merge before so I am not sure, if I must use cursor or just this statement should be fine