create or replace procedure aa
as
begin
for i in 1..200000 loop
insert into t_1_mtbuf(id,msg,mobile,spcode) values(seq_bufid.nextval,'00000','15900000000','8888');
end loop;
end;
oracle存储过程循环插入10000条数据
最新推荐文章于 2022-07-05 16:37:51 发布