oracle 批量插入数据

insert into 表名(字段1,字段2) 
select '一','二' from dual         
union all                                 
select '三','四' from dual         
union all                                 
select '五','六' from dual         
union all                                 
select '七','八' from dual         
union all                                 
select '九','十' from dual     

 

mybatis 配置

 

<insert id="test" parameterType="list">
     insert into test(id,name)
    <foreach collection="list" separator="union all" index="index" item="obj">
        select  #{obj.id},#{obj.name} from dual
    </foreach>
  </insert>