MERGE STATEMENT

MERGE INTO [table 명] [테이블 별칭]
    USING [ 대상 table/view ] [ 대상 table/view 별칭 ]
    ON [ join 조건 ]
    WHEN MATCHED THEN
        UPDATE SET
           col1 = value1
               col2 = value2
    WHEN NOT MATCHED THEN
       INSERT ( column 명, , , , )
       VALUES ( value1, , , , , , );