MyBatis Oracle批量更新

    <update id="updateProductSerialNo" parameterType="java.util.List">
        <foreach collection="list" item="it" separator=";" open="begin" close="end;">
            update ERP_PRODUCT_ID_NAME
            set SERIAL_NO = #{it.serialNo,jdbcType=DECIMAL}
            where PRODUCT_ID = #{it.productId,jdbcType=VARCHAR}
        </foreach>
    </update>