Oracle MERGE例子MERGE INTO TEST T1USING (SELECT aa AS f1, bb AS f2 FROM DUAL) T2ON (T1.f1 T2.f
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')
?