Oracle+mybatis实现批量插入
1.采用union all
<insert id="insertByBatch"parameterType="java.util.List"> insert into table( name, user_id, age ) <foreach collection="ist" item="item" index="index"separator="UNION ALL"> select ( #fitem.name} #fitem.user_id} #fitem.age from dual ) </foreach> </insert>