create table ABING1 ( ID1 NVARCHAR2(100), NAME1 NVARCHAR2(100) ) create table ABING2 ( ID2 NVARCHAR2(100), NAME2 NVARCHAR2(100) ) merge into abing1 t using abing2 s on(t.id1=s.id2) when matched then update set t.name1=s.name2 when not matched then insert values (s.id2,s.name2); commit
|