oracle批量插入数据sql语句

最新推荐文章于 2024-07-17 19:00:48 发布

weixin_34320159

最新推荐文章于 2024-07-17 19:00:48 发布

阅读量2.5k

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/zhangmaoyuan/blog/2052410

版权

2019独角兽企业重金招聘Python工程师标准>>>

insert all  when (not exists (select 1 from tableName where id = '2222222222224')) then into tableName(id,name) values('222222222222','xxx')  when (not exists (select 1 from tableName where id = '000025d9-5fbc-4277-b547-fd0737d8b274')) then into tableName(id,name) values('000025d9-5fbc-4277-b547-fd0737d8b274','yyyyy')  select 1 from dual

转载于:https://my.oschina.net/zhangmaoyuan/blog/2052410