Question

oracle中如何insert 3000条自增的数据，例如 插入 3000条id=1至id=3000并且其他字段都是一致的数据

Answer 1

1、在oracle中添加一个序列
2、在你要添加数据的表中创建一个触发器，当插入一条数据的时候就从序列中拿一个值并且赋给id

Answer 2

create table test
(
id number,
name varchar2(20)
)

begin
for i in 1..3000 loop
insert into test values(i,'aa');
end loop;
end;

Answer 3

/*创建表*/
Create table c_volunteer_dispatch
(
id number primary key,
phone_record_id number,
)

/*创建序号*/
Create sequence seq_volunteer_dispatch
minvalue 1
increment by 1
start with 1;

/*创建触发器*/
Create or replace trigger tigger_volunteer_dispatch
before insert on c_volunteer_dispatch
for each row
begin
select seq_volunteer_dispatch.nextval into :new.id from dual;
end;