declare
n number:=0;
begin
loop
insert into sample values(1,'name','sexw','address');
n:=n+1;
exit when n=100;
end loop;
end;
/
n number:=0;
begin
loop
insert into sample values(1,'name','sexw','address');
n:=n+1;
exit when n=100;
end loop;
end;
/
declare
n number:=0;
begin
loop
insert into sample values(1,'name'||' '||n,n||'sexw','address'||' '||n);
n:=n+1;
exit when n=100;
end loop;
end;
/
试一下,如果不行,就把n转化为字串再拼上,数据就不相同了。
SELECT ROWNUM,'name','sexw','address' FROM TABLE WHERE ROWNUM<=100