MERGE INTO HW_EHR_CODE_SHEET_CONFIG_T T
USING (SELECT #countryActivityId# ACTI_REGION_ID,
#formType# SHEET_FUNCTION,
#formName# SHEET_NAME,
#status# STATUS,
#lastUpdatedBy# LAST_UPDATE_BY
FROM DUAL) TMP
ON (T.ACTI_REGION_ID = TMP.ACTI_REGION_ID AND T.SHEET_FUNCTION = TMP.SHEET_FUNCTION)
WHEN MATCHED THEN
UPDATE
SET T.SHEET_NAME = TMP.CONFIG_NAME,
T.STATUS = TMP.STATUS,
T.LAST_UPDATE_DATE = SYSDATE,
T.LAST_UPDATE_BY = TMP.LAST_UPDATE_BY
WHEN NOT MATCHED THEN
INSERT
(CONFIG_ID,
ACTI_REGION_ID,
SHEET_FUNCTION,
SHEET_NAME,
STATUS,
CREATED_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_BY)
VALUES
using什么用法?
USING (SELECT #countryActivityId# ACTI_REGION_ID,
#formType# SHEET_FUNCTION,
#formName# SHEET_NAME,
#status# STATUS,
#lastUpdatedBy# LAST_UPDATE_BY
FROM DUAL) TMP
ON (T.ACTI_REGION_ID = TMP.ACTI_REGION_ID AND T.SHEET_FUNCTION = TMP.SHEET_FUNCTION)
WHEN MATCHED THEN
UPDATE
SET T.SHEET_NAME = TMP.CONFIG_NAME,
T.STATUS = TMP.STATUS,
T.LAST_UPDATE_DATE = SYSDATE,
T.LAST_UPDATE_BY = TMP.LAST_UPDATE_BY
WHEN NOT MATCHED THEN
INSERT
(CONFIG_ID,
ACTI_REGION_ID,
SHEET_FUNCTION,
SHEET_NAME,
STATUS,
CREATED_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_BY)
VALUES
using什么用法?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货