文章列表
命令行模式下：
//执行语句，创建存储过程
CREATE OR REPLACE PROCEDURE Insertdata_Proc(maxnum IN NUMBER) AS
BEGIN
FOR i IN 1..maxnum LOOP
insert into Table_T(A,B,C)VALUES (i,'s'||i,to_char(sysdate,'yyyymmddhh24miss'));
END LOOP;
COMMIT;
END Insertdata_Proc;
//调用存储过程，增加10万条数据
Begin
Insertdata_Proc(10000 ...