declare i number(3); begin i:=0; loop exit when i>100; insert into test values('111'); i++; end loop; end
declare i number(3); begin i:=0; loop exit when i>100; insert into test values('111'); i:=i+1; end loop; end;
忘记加COMMIT了 declare i number(3); begin i:=0; loop exit when i>100; insert into test values('111'); i++; end loop; commit; end
测试结果如下 create table test (id number(3)); 运行代码 declare i number(3); begin i:=0; for i in 1..100 loop insert into test values('111'); end loop; end;查看结果 SQL> select * from test;
begin
i:=0;
loop
exit when i>100;
insert into test values('111');
i++;
end loop;
end
begin
i:=0;
loop
exit when i>100;
insert into test values('111');
i:=i+1;
end loop;
end;
declare i number(3);
begin
i:=0;
loop
exit when i>100;
insert into test values('111');
i++;
end loop;
commit;
end
create table test (id number(3));
运行代码
declare i number(3);
begin
i:=0;
for i in 1..100
loop
insert into test values('111');
end loop;
end;查看结果
SQL> select * from test;
ID
----
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
ID
----
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
ID
----
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
ID
----
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
ID
----
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
111
100 rows selected