可以插入多条的：
1.insert into table_name1 select * from table_name2;
2.用insert all语句（和4楼的做法一样）。

insert into tablename select 'a1','a2','a3' from dual union all
select 'b1','b2','b3' from dual union all
select 'c1','c2','c3' from dual