mybatis 批量插入 oracle

 

 

<insert id="insertMultiple" parameterType="java.util.List">
    insert
    into KM_SIMILAR_QUESTION
    (ID, QUESTION_ID,
    SIMILAR_QUESTION, AUDIT_STATUS, CREATED_BY,
    DATE_CREATED, UPDATED_BY, DATE_UPDATED,CATEGORY_ID)
    <foreach collection="list" item="item" index="index" separator="union all">
        (
        select
        sys_guid(), #{item.questionId,jdbcType=VARCHAR},
        #{item.similarQuestion,jdbcType=VARCHAR}, #{item.auditStatus,jdbcType=VARCHAR},
        #{item.createdBy,jdbcType=VARCHAR},
        sysdate, #{item.updatedBy,jdbcType=VARCHAR}, sysdate, #{item.categoryId,jdbcType=VARCHAR}
        from dual
        )
    </foreach>
</insert>