Mybatis批量将list数据插入到Oracle数据库

foreach属性

 xml

insert into u_test ( id,lcid)
        <foreach collection="list" item="item" index="index" separator=" union all" open="(" close=")">
        select
            #{item.id},
            #{item.lcid} from dual
         </foreach>        

正常批量执行SQL

INSERT INTO u_test(id, lcid) (select '1','123' from dual union all select '2','345' from dual)