mybatis oracle 循环list批量插入 带序列

• <insert id="insertGys" parameterType="java.util.List" useGeneratedKeys="false">
      insert into table
      (zbid,xmid,gysmc,zbje,htje,iszb,tyshxydm,gyssqdb,sqdbsfzh,gysxmfzr,
      xmfzrsfzh,ybpj,lypj,blxwjl,bz,lxdh)
      select seq_xtxmzbxx.nextval,A.* from (
      <foreach collection="list" item="gys" index="index" separator="UNION ALL">
      select
          #{gys.xmid},#{gys.gysmc},#{gys.zbje},#{gys.htje},#{gys.iszb},#{gys.tyshxydm},
          #{gys.gyssqdb},#{gys.sqdbsfzh},#{gys.gysxmfzr},#{gys.xmfzrsfzh},#{gys.ybpj},
          #{gys.lypj},#{gys.blxwjl},#{gys.bz},#{gys.lxdh}
          from dual
      </foreach>
      )A
  </insert>