oracle insert 批量插入数据,跳过已存在记录
insert into tree(id,name,pid) select '101','test','10' from dual where not exists(select 1 from tree where id='101');orinsert when (not exists (select 1 from tree where id='101')) then into tree(id,na...
转载
2018-03-29 15:48:27 ·
10441 阅读 ·
0 评论