[ORACLE] MERGE INTO 한방정리

MERGE INTO A_TABLE B
USING B_TABLE B
ON
(
    A.NO = '0'
    A.ID = B.ID
)
WHEN MATCHED THEN
UPDATE
SET
    VAL1 = B.VAL1
,   VAL2 = B.VAL2
;

[출처] Oracle Update Join|작성자 라이오스