Oracle MERGE例子

MERGE INTO TEST T1USING (SELECT 'aa' AS f1, 'bb' AS f2 FROM DUAL) T2ON (T1.f1= T2.f1AND T1.f2= T2.f2)WHEN MATCHED THEN  UPDATE     SET f3     = '1',         f4   = '01',         f5  = '11',         f6       = '111',         f7    = '01',         f8 = SYSTIMESTAMPWHEN 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')

?