mybitis oracle批量修改 。oracle 和mysql 注意 foreache 有区别

<update id="bathUpdate" parameterType="java.util.List">
		<foreach collection="list" item="entity" index="index" open="begin" close=";end;" separator=";">
		update WI_WATER_DAY_M
			<set>
					SINGULAR_VALUE = #{entity.singularValue,jdbcType=VARCHAR}
			</set>
			where MEAS_ID = #{entity.measId,jdbcType=VARCHAR}
 			and  DATE_STR = #{entity.dateStr,jdbcType=VARCHAR}
		</foreach>
	</update>