The following example uses target table t1 as its source table:
MERGE INTO t1 USING t1 AS s ON t1.a1 = s.a1 WHEN MATCHED THEN UPDATE SET b1 = 10 WHEN NOT MATCHED THEN INSERT VALUES (s.a1, s.b1, s.c1);
The following example uses target table t1 as its source table:
MERGE INTO t1 USING t1 AS s ON t1.a1 = s.a1 WHEN MATCHED THEN UPDATE SET b1 = 10 WHEN NOT MATCHED THEN INSERT VALUES (s.a1, s.b1, s.c1);