首先创建一个表,
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;