SQLD · 제61회 · 40번

MERGE INTO EMP E
USING EMP_TEMP T
ON (E.EMP_ID = T.EMP_ID)
WHEN MATCHED THEN
    UPDATE SET E.EMP_NAME = T.EMP_NAME
WHEN NOT MATCHED THEN
    INSERT (EMP_ID, EMP_NAME) VALUES (T.EMP_ID, T.EMP_NAME);