mybatis + oracle + 自增id 批量插入

1、oracle建索引 就不说了
2、mapper.xml
<insert id="saveRemarks" parameterType="java.util.List">
    insert into BZ_MDCH_ITEM_DISTANCE_REMARK(ID, 
               PARENT_ID, 
               REMARK_ORDER, 
               LIMIT_CONDITION, 
               TAXIWAY_CODE, 
               RUNWAY_NUM,
               ENTER_MOVEIN_DISTANCE,
               ENTER_MOVEIN_DISTANCE_UNIT)
    select SEQ_MDCH_ITEM_DISTANCE_REMARK.NEXTVAL id,r.* from (
    <foreach collection="list" item="remark" index="index" separator="union all">
        select
        #{remark.parentId, jdbcType=DECIMAL}, 
        #{remark.remarkOrder, jdbcType=DECIMAL}, 
        #{remark.limitCondition, jdbcType=VARCHAR},
        #{remark.taxiwayCode, jdbcType=VARCHAR}, 
        #{remark.runwayNum, jdbcType=VARCHAR}, 
        #{remark.enterMoveinDistance, jdbcType=VARCHAR}, 
        #{remark.enterMoveinDistanceUnit, jdbcType=VARCHAR}
        from DUAL
    </foreach>
    ) r
</insert>