ORACLE MERGE INTO DELETE

原创于 2019-08-14 10:38:39 发布 · 2.4k 阅读

4 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#oracle merge into delete

oracle 专栏收录该内容

2 篇文章

订阅专栏

本文详细解析了Oracle数据库中MERGE语句的使用方法，重点介绍了如何通过MERGE语句实现数据更新与删除操作。示例展示了当源表与目标表数据匹配时进行更新，并在特定条件下执行删除操作的具体语法。

ORACLE MERGE INTO DELETE

注意源表和目标表数据都要唯一

merge into PERSONCERTIFICATEBAK b
using (select ids from person_cer_dele ) u
on (b.id = u.ids)
when matched then 
update set b.personguid = b.personguid
delete where (b.id = u.ids);