[Quote=引用 1 楼 xustanly 的回复:]
1.insert into [Table](field1,field2,field3)
select 'f11','f21','f31' union all
select 'f12','f22', 'f32' union all
select 'f13','f23','f33'
构成如上的SQL语句
insert into [table]
select value10,value20,...valuen0 union all
select value11,value21,...valuen1 union all
.....
select value1n,value2n,...valuenn union all
或者在function中用pl/sql的循环语法
或者insert into table1 (xx,xxx) select xx,xxx from table2