[ORACLE] MERGE INTO 구문

MERGE INTO <TABLENAME> AS A
    USING DUAL
       ON (A.COLUMN_1 = 'A' 
           AND A.COLUMN_2 = 'B')
    WHEN MATCHED THEN
        UPDATE SET A.COLUMN_3 = 'C'
    WHEN NOT MATCHED THEN
        INSERT (A.COLUMN_1, A.COLUMN_2, A.COLUMN_3)
        VALUES ('A', 'B', 'C')

;

 

자주쓰는데 헷갈린다...

 

블로그에 박제후 사용