본문 바로가기
업무용/오라클

merge into (update insert동시에)

by SEOKIHOUSE 2024. 4. 17.

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>