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 NOT MATCHED THEN
INSERT
(T1.PAGE_ID, T1.CHART_OPTION)
VALUES
(T2.PAGE_ID, T2.CHART_OPTION);