oracle循环插入数据
declare
i number;
begin
for i in 1..1000 loop
insert into employee (id, createtime, adder_id, adder_name,source_type) values (i, ‘2017-02-10 12:11:29’, ‘8888’, ‘admin’ , ‘web’)
end loop;
end;
declare
i number;
begin
for i in 1..1000 loop
insert into employee (id, createtime, adder_id, adder_name,source_type) values (i, ‘2017-02-10 12:11:29’, ‘8888’, ‘admin’ , ‘web’)
end loop;
end;