写个存储过程CREATE OR REPLACE PROCEDURE Create_Test_Data
(
v_loopnum in number
) IS
v_loop NUMBER;
BEGIN
v_loop := 1;
LOOP
EXIT WHEN v_loop=v_loopnum;
INSERT INTO TABLENAME(字段1,字段2,字段3,字段4) VALUES(v_loop_tmp,字段2,字段3,字段4);
v_loop:=v_loop+1;
END LOOP;
commit;
END Create_Test_Data;复制代码