Oracle Merge / Dual / Using on 등가 조인 / When Matched / When Not 사용 예시

MERGE INTO T_WEEKLYWORK_SUB
USING DUAL
ON ( WEEKLYWORK_HIST_ID = #{seq ,jdbcType=INTEGER} AND WORK_DIV = #{workDiv ,jdbcType=VARCHAR})
WHEN MATCHED THEN
UPDATE SET
      B_WEEK = #{bWeek ,jdbcType=VARCHAR}
    , N_WEEK = #{nWeek ,jdbcType=VARCHAR}
    , MOD_DATE = SYSDATE
    , MOD_ID = #{loginId ,jdbcType=VARCHAR}
WHEN NOT MATCHED THEN
INSERT (
      WEEKLYWORK_HIST_ID
    , WORK_DIV
    , N_WEEK
    , B_WEEK
    , REG_DATE
    , REG_ID
) VALUES (
      #{seq ,jdbcType=INTEGER}
    , #{workDiv ,jdbcType=VARCHAR}
    , #{nWeek ,jdbcType=VARCHAR}
    , #{bWeek ,jdbcType=VARCHAR}
    , SYSDATE
    , #{loginId ,jdbcType=VARCHAR}
)