MERGE example (oracle)

merge.sql

MERGE INTO tab D
USING (SELECT 99999 as id_c1,
              SYSDATE as c2,
              'klashxx' as c3,
              'test' as c4,
              'test' as c5,
              'test' as c6,
              'not_matched' as c7
         FROM DUAL) S
ON (D.id_c1 = S.id_c1)
WHEN MATCHED THEN
  UPDATE SET D.c7 = 'matched'
WHEN NOT MATCHED THEN
  INSERT VALUES (S.id_c1, S.c2, s.c3, s.c4, s.c5, s.c6, s.c7);