merge into t_test t
using (select * from t_test_bak) bak
on (t.D = bak.D)
when matched then
update set t.A = bak.A
when
Oracle根据主键新增或修改
![](https://img-home.csdnimg.cn/images/20240711042549.png)
merge into t_test t
using (select * from t_test_bak) bak
on (t.D = bak.D)
when matched then
update set t.A = bak.A
when