create or replace procedure msw_add is
begin
for i in 1 ..100000 loop
insert into t1(id,name) values(i, sysdate);
end loop;
end msw_add;
/
oracle 存储过程循环插入10000条记录---存储过程
最新推荐文章于 2024-07-12 15:04:40 发布
create or replace procedure msw_add is
begin
for i in 1 ..100000 loop
insert into t1(id,name) values(i, sysdate);
end loop;
end msw_add;
/