循环插入oracle 存储过程

-- Create table
create table STUDENTS
(
name VARCHAR2(300),
id NUMBER(11),
city VARCHAR2(300),
no VARCHAR2(300)
);

 

CREATE OR REPLACE PROCEDURE test
IS
BEGIN
for i in 1 ..100000 loop
insert into STUDENTS values('ff',i,'sss','dd');
end loop;
commit;
END;

 

commend : exec test;