mybatis Oracle的批量插入与MySQL不同
<insert id="insetList" parameterType="java.util.List" useGeneratedKeys="false">
insert into T_INSPOLCY_CHECKFORBATCH (ID,INSPOLCYNO,INSBILLNO,BATCHPAGENAME,INPUTDATE,BTCHBILLNO)
select POLCY_CHECKFORBATCH_SEQ.nextval ID,A.* from (
<foreach collection="list" item="batch" index="index" separator="union all">
select
#{batch.INSPOLCYNO} INSPOLCYNO,#{batch.INSBILLNO} INSBILLNO,#{batch.BATCHPAGENAME} BATCHPAGENAME,sysdate INPUTDATE,#{batch.BTCHBILLNO} BTCHBILLNO
from dual
</foreach>
) A
</insert>