首先创建一个表,
create table a ( name varchar2(10) )
1、然后插入数据
insert all into a values(1) into a values(3) into a values(5) into a values(1) into a values(3) into a values(5) select * from dual;
2、合并方法
insert into a (name) select 8032 FROM DUAL union select 8033 FROM DUAL union select 8034 FROM DUAL
3、从一个表中读取多行数据,可以是其他表,也可以是表自身
insert into a (name) select * from a;
4、通过序列插入多行,seq_area为一个序列
insert into a(name) SELECT seq_area.nextval from dual;