提供参考 DECLARE BEGIN merge INTO t17_organ t1 USING t40_organ t2 ON t1.organno=t2.organno WHEN matched THEN UPDATE SET t1.organname=t2.organname, t1.organlevel =t2.organlevel, t1.uporgankey =t2.uporgankey, t1.flag =t2.flag ; COMMIT; END; /
根据你现有的内容,做个完全同步的 merge into frp.t17_organ d using frp.t40_organ s on (s.organno=d.organno) when matched then update set d.organname=s.organname,..... when not matched then insert values (s.organno.........)