--建表
create table t (id number,name varchar2(20));
insert into t values ('1','kshg');
--建procedure(插入10000条记录)
create or replace procedure test
as
begin
for i in 2..10000 loop
insert into t values ('9','hguih');
commit;
end loop;
end test;
exec test;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22123669/viewspace-674585/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22123669/viewspace-674585/