[SQL] MERGE

[SQL] MERGE

MERGE INTO WORK_MBR USING DUAL ON (CUST_SSTM_CD = #{custSstmCd} AND CU_CD = #{cuCd})   WHEN MATCHED THEN   <!-- 위의 조건이 맞는게 있다면 UPDATE -> UPDATE SET ROLE_CD = #{roleCd} WHEN NOT MATCHED THEN  <!--  위의 조건이 아니라면 INSERT  -> INSERT ( CUST_CD, CUST_SSTM_CD, CU_CD, ROLE_CD ) VALUES ( #{custCd}, #{custSstmCd}, #{cuCd}, #{roleCd} )