oracle mybatis批量插入数据，批量更新数据(与mysql不一样)_AoLuo的博客_oracle批量更新数据mybatis

1. oracle批量插入数据写法

    <insert id="insertIndexConsumer" parameterType="java.util.List">
        insert all
        <foreach collection ="dmspIndexConsumer" item="item" separator ="">
            into DMSP_CONSUMER_INDEX_RELATION (CONSUMER_CODE, INDEX_ID)
            values (#{item.consumerCode,jdbcType=VARCHAR}, #{item.indexId,jdbcType=VARCHAR})
        </foreach >
        select 1 from dual
    </insert>
    <insert id="