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')