Oracle 批量插入（insert all into）

oracle 批量新增sql

  <insert id="insertForBatch">
    INSERT INTO
    ATTENDANCE_OVERTIMEINFO
    (ID,EHR_TENANT_ID, USERID, STATUS, ISHOLIDAY, BEGINTIME, ENDTIME,TYPE,REASON
    ,CREATEUSERID, CREATETIME, UPDATEUSERID, UPDATETIME,LASTUPDATETIME,HOURS,REMARK)
    <foreach item="item" collection="list" separator="union all" index="index">
      select #{item.id,jdbcType=VARCHAR},
      #{item.ehrTenantId,jdbcType=VARCHAR},
      #{item.userid,jdbcType=VARCHAR},
      #{item.status,jdbcType=INTEGER},
      #{item.isholiday,jdbcType=INTEGER},
      #{item.begintime,jdbcType=TIMESTAMP},
      #{item.endtime,jdbcType=TIMESTAMP},
      #{item.type,jdbcType=VARCHAR},
      #{item.reason,jdbcType=VARCHAR},
      #{item.createuserid,jdbcType=VARCHAR},
      #{item.createtime,jdbcType=TIMESTAMP},
      #{item.updateuserid,jdbcType=VARCHAR},
      #{item.updatetime,jdbcType=TIMESTAMP},
      #{item.lastupdatetime,jdbcType=TIMESTAMP},
      #{item.hours,jdbcType=INTEGER},
      #{item.remark,jdbcType=VARCHAR}
      from dual
    </foreach>
  </insert>