命令行模式下：
//执行语句，创建存储过程
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(100000);
End；
//执行语句，创建存储过程
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(100000);
End；
扫一扫
543
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
