mybatis foreach 批量操作

oracle批量插入

<insert id="batchInsertData" parameterType="List">
		insert into t_b (type,t_type,t_name)
		<foreach collection="list" item="item" index="index" separator="UNION ALL">
			select #{item.type},#{item.t_type},#{item.t_name} FROM DUAL
		</foreach>
</insert><insert id="batchInsertData" pa