merge into table t1 using (select '123' ID,'aa' Name from dual) t2 on (t1.ID = t2.ID) when matched then update set t1.Name = t2.Name when not matched then insert values (t2.ID, t2.Name); commit;
oracle表中存在数据就修改,没有数据自动添加 的sql语句
最新推荐文章于 2024-07-18 19:28:01 发布