Oracle MERGE例子

MERGE INTO TEST T1
USING (SELECT 'aa' AS f1, 'bb' AS f2 FROM DUAL) T2
ON (T1.f1= T2.f1AND T1.f2= T2.f2)
WHEN MATCHED THEN
  UPDATE
     SET f3     = '1',
         f4   = '01',
         f5  = '11',
         f6       = '111',
         f7    = '01',
         f8 = SYSTIMESTAMP
WHEN NOT MATCHED THEN
  INSERT
    (f0,
     f3,
     f2,
     f4,
     f5,
     f1,
     f6,
     f7,
     f9,
     f8,
     f10)
  VALUES
    (WHITEMOBILE_SEQ.NEXTVAL,
     '2',
     'bb',
     '01',
     '12',
     '106100001',
     '12',
     '01',
     1,
     SYSTIMESTAMP,
     'aa')