<insert id="batchInsert" parameterType="java.util.List" useGeneratedKeys="false">
insert into XX_XX(XX,XX,XX,XX,XX,XX,XX,XX)
select XX.Nextval,a.* from(
<foreach collection="list" item="item" separator="union">
select
#{item.xx},#{item.xx},#{item.xx},#{item.xx},to_date(#{item.xx},'yyyy-mm-dd hh24:mi:ss'),#{item.xx},#{item.xx}
from dual
</foreach>
) a
</insert>
Oracle+Mybatis批量插入包含序列的使用
最新推荐文章于 2023-11-10 10:56:00 发布