create or replace procedure BATCH_INSERT_TABLEA_UER(insertNo in integer) is
-----------insertNo:传入参数,表示要插入的数据量
MAX_NO INTEGER;
I INTEGER;
BEGIN
IF insertNo IS NOT NULL THEN
MAX_NO:=insertNo;
ELSE
MAX_NO:=0;
END IF;
FOR I IN 1 ..MAX_NO loop
INSERT INTO t_user(userid,username,password,phone,relname,email,age,sex)
VALUES(I||'','user_'||I,'123','18888888888','李'||I,'735125342@qq.com',11,1);
IF mod(I,100)=0 THEN
COMMIT;
END IF;
end LOOP;
end BATCH_INSERT_TABLEA_UER;