declare
i integer
begin
i:=1
loop
insert into user(id, name, password,...)
values(to_char(i),'张新喜' + to_char(i),...);
i:=i+1;
exit when i > 100000;
end loop;
commit;
end;
i integer
begin
i:=1
loop
insert into user(id, name, password,...)
values(to_char(i),'张新喜' + to_char(i),...);
i:=i+1;
exit when i > 100000;
end loop;
commit;
end;