循环插入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;

原文地址:https://www.cnblogs.com/adolfmc/p/3412542.html