使用MERGE

Oracle 使用MERGE INTO 语句 一条语句搞定新增编辑

MERGE INTO RDP_CHARTS_SETTING T1 USING (SELECT '10001' AS PAGE_ID, 'test' AS CHART_OPTION FROM DUAL) T2 ON (T1.PAGE_ID = T2.PAGE_ID) WHEN MATCHED THEN UPDATE SET T1.CHART_OPTION = T2.CHART_OPTION WHEN...