MERGE INTO EZ_PRM_CLIENT A
USING (
SELECT #prmCd# PRM_CD
, #clientCd# CLIENT_CD
, #ctgTypeCd# CTG_TYPE_CD
FROM DUAL ) B
ON (
A.PRM_CD = B.PRM_CD
AND A.CLIENT_CD = B.CLIENT_CD
AND A.CTG_TYPE_CD = B.CTG_TYPE_CD
)
WHEN MATCHED THEN
UPDATE SET USE_YN = 'Y'
, MODI_DT = #modiDt#
WHEN NOT MATCHED THEN
INSERT (
PRM_CD, CLIENT_CD
, CTG_TYPE_CD, USE_YN
, REG_MGR_ID, REG_DT
)
VALUES (
B.PRM_CD, B.CLIENT_CD
, B.CTG_TYPE_CD, 'Y'
, #regMgrId#, #regDt#
)