Oracle 批量添加 其他语句回报 SQL语句未结束 的错误
<insert id="insertedTemp" parameterType="java.util.List">
insert into TEST_XXX (ID,NAME) VALUES
<foreach collection="list" item="item" index="index" separator=",">
(#{item.Id,jdbcType=VARCHAR},
#{item.chkFlag,jdbcType=VARCHAR})
</foreach>
</insert>
修改为:
<insert id="csgzjzInsertData" parameterType="java.util.List">
INSERT INTO TEST_XXX
(NY, GLQ, ... )
<foreach collection ="list" item="item" separator="UNION ALL" >
<if test="item != null and item.size() > 0">
select
#{item.NY,jdbcType=VARCHAR},
#{item.GLQ,jdbcType=VARCHAR},
...
from dual
</if>
</foreach >
</insert>