Oracle循环插入测试数据

declare                                                                //定义部分标识
   maxrecords constant int:=9999;                  //定义 maxrecords 为整型常量
   i int:=7000;                                                    //定义i为整型变量，初值为7000
   
  Begin                                                                //执行部分标识
    for i in 7000..maxrecords loop                    //i从7000循环到maxrecords 
      insert into wlxy.wlxy_users(username,password,truename,datetime,ischeck,typeid,sex) values('nbec'||i,'123456','nbec'||i,sysdate,1,0,'男');        //向数据表中插入数据
    end loop;//结束循环
   dbms_output.put_line(' 成功录入数据！ '); //显示数据成功插入
  commit;                                                            //提交结果
 end;                                                                   //结束执行