oracle批量插入数据

第一种方案

public String bunchInsert(int min,int max) {
        
        StringBuilder sb=new StringBuilder();
        sb.append("INSERT ALL ");
        for(int i=min;i<max;i++) {
            sb.append("   INTO tableName(id, name) values('"+i+"','"+i+"')");
        }
        sb.append("select * from dual");
        String sql = sb.toString();
        
        return sql;
    }

第二种方案：

insert all 
 into tableName values('1')
 into tableName values('2')
 into tableName values('3')
 into tableName values('4')
select 1 from dual;

mybatis写法：
insert all 
<foreach collection = "list" item= "item" separator=" ">
    into tableName (id,name) values (#{item.id},#{item.name})
</foreach>
select 1 from DUAL