oracle存储过程循环插入10000条数据

 

create or replace procedure aaasbegin    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;