업무용/오라클
merge into (update insert동시에)
SEOKIHOUSE
2024. 4. 17. 10:21
ON에 괄호안하면 오류가 나더라 ㅇㅅㅇ
<update id="updateInsertGridData" parameterType="orgjbptoMngVo">
MERGE INTO ${PM}.TB_ORGJBPTO_MNG
USING DUAL
ON
(ORG_JBPS_TO_SN = #{orgJbpsToSn})
WHEN MATCHED THEN
UPDATE SET
JBPS_CD = #{jbpsCd}
, SORT_SEQ = #{sortSeq}
, TO_CNT = #{toCnt}
, MEMO_CN = #{memoCn}
, MDFCN_DT = SYSDATE
, MDFR_EMPNO = #{mdfrEmpno}
WHEN NOT MATCHED THEN
INSERT
(
ORG_JBPS_TO_SN
, TO_CRT_CRTR_YMD
, ORGCD
, DEPT_ORGCD
, SORT_SEQ
, JBPS_CD
, TO_CNT
, MEMO_CN
, REG_DT
, RGTR_EMPNO
) VALUES
(
${PM}.TB_ORGJBPTO_MNG_SN.NEXTVAL
, #{toCrtCrtrYmd}
, #{orgcd}
, #{deptOrgcd}
, #{sortSeq}
, #{jbpsCd}
, #{toCnt}
, #{memoCn}
, SYSDATE
, #{rgtrEmpno}
)
</update>