<insert id="batchInsert" parameterType="java.util.List">
insert into user
<trim prefix="(" suffix=")" suffixOverrides=",">
ID,
NAME,
AGE
</trim>
select USER_ID_SEQ.nextval ID, A.*
FROM
<foreach collection="list" item="item" separator="UNION ALL" open="(" close=")">
SELECT
#{item.name,jdbcType=VARCHAR},
#{item.age,jdbcType=DECIMAL}
FROM dual
</foreach>
A
</insert>