merge into tablea a using tableb b on (a.col1=b.col1 [and 其他限制条件]) when matched then update set a.col2=b.col2
oracle merge into 方式更新某个字段值等于另外一张表的某个字段值
最新推荐文章于 2024-07-18 17:41:34 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
merge into tablea a using tableb b on (a.col1=b.col1 [and 其他限制条件]) when matched then update set a.col2=b.col2