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

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)