oracle mybatis 批量insert

<insert id="insertBatch" parameterType="java.util.List" >
  insert into table(A,B,C,D,CREATED_DATE)
  SELECT t.*
    FROM (
      <foreach collection="list" item="item" separator="UNION ALL">
        SELECT
          #{item.a} AS A,
          #{item.b} AS B,
          #{item.c} AS C,
          #{item.d} AS D,
          SYSDATE AS CREATED_DATE
            FROM dual
    </foreach>
      ) t
</insert>

posted @ 2020-12-28 15:48  jackwu74  阅读(596)  评论(0)    收藏  举报