Oracle实现存在更新不存在插入merge into
使用merge into 实现存在即更新不存在即插入
类似 mysql的on duplicate key update
merge into BUSI_TASERIAL_STATUS bts
using ( select 'cs0001' as taserialno,'0' as notify_status from dual
union all
select 'cs0002' as taserialno,'0' as notify_status from dual
union all
select 'cs
原创
2020-06-05 13:49:44 ·
552 阅读 ·
0 评论