MERGE INTO AUEIC.SGLS_CP_CTRL_POWER A
USING(
SELECT CON.DEMAND_ID,
CON.CURVE_TYPE,
CON.P1,
CON.P2
FROM DUAL CON
) C
ON (A.DEMAND_ID=C.DEMAND_ID AND
A.CURVE_TYPE=C.CURVE_TYPE)
WHEN MATCHED THEN
UPDATE SET A.P1=C.P1
WHEN NOT MATCHED THEN
INSERT
(A.P1,
A.CURVE_TYPE,
A.P2)
VALUES(
C.P1,
C.CURVE_TYPE,
C.P2)
简单的merge模板
最新推荐文章于 2022-08-11 21:58:16 发布