Oracle批量输入测试数据

存储过程实现oracle测试数据的批量输入，用户名user_name，存储过程名procedure_name，表名stu，列名：id,name,dept,age,sex,score。以插入100个数据为例，存储过程如下：

create or replace procedure "user_name"."procedure_name" as begin declare v_i number(10); begin v_i := 1; while v_i < 100 loop insert into stu(id,name,dept,age,sex,score) values(v_i,'stu'||v_i,'jsj','23','女','125'); if mod(v_i,10)=0 then commit; end if; v_i := v_i + 1; end loop; commit; exception when others then rollback; dbms_output.put_line(sqlerrm); end; end;

 

执行语法：exec procedure_name;