oracle mybatis批量插入效率快些

datalist中map的顺序需要与lineColumn对应
<insert id="insertIndi" parameterType="java.util.HashMap" useGeneratedKeys="false">
   <![CDATA[
      INSERT INTO TABLEA(${lineColumn})
      select results.* from(
      ]]>
   <foreach collection="datalist" item="item" index="index" separator="union all" >
      (select
      <foreach collection="item.values" index="key" item="_value" separator=",">
         #{_value}
      </foreach>
      from dual)
   </foreach>
   <![CDATA[) results]]>
</insert>

oracle mybatis批量插入效率快些

原文：https://www.cnblogs.com/sx2zx/p/10832320.html