INSERT INTO LC_BANJIE(ID,DISPATCH_STATE)
<foreach collection="list" item="item" index="index" separator="union all">
(select #{item},'0' from dual)
</foreach>
mybatis oracle批量插入
最新推荐文章于 2024-03-08 14:05:57 发布
INSERT INTO LC_BANJIE(ID,DISPATCH_STATE)
<foreach collection="list" item="item" index="index" separator="union all">
(select #{item},'0' from dual)
</foreach>