oracle创建测试数据

-- Created on 2011-10-21 by WKF46214
declare
  -- Local variables here
  num integer;
  islargeacct number(1);
  clientnum number(2);
begin
  -- Test statements here
  num:=1000000;
  clientnum:=0;
  for n in 1..num loop
      if mod(n,2)=0 then
         islargeacct:=0;
      else islargeacct:=1;
      end if;
      clientnum:=clientnum+1;
      if (clientnum=20) then
         clientnum:=0;
      end if;
    insert into aa(id, islargeacct, internetusername, clientnum, ismonitor, receiveflag, modifytime, regionid, custname, custtype, usertype, serviceid, servicetype, servicestatus, custindustrytype, professiontype, custlevel, rate, installaddress, accesstype, connectiontype, adsltype, xdsltype, supportbusinesstype, areacode, accessnbr, firstcompletetime, updatetime, pcts, xfzh, sbxh, sbbh, sbdzh, ypdzh, ssfj, ssjd, khjl, lxdh, recv1, recv2, recv3, recv4, recv5, recv6, recv7, recv8, recv9, recv10)
    values(n, islargeacct, 'user_'||n, clientnum, 0, 0, '20111021143000', 310001, 'CustName_'||n, 1, 0,
           0, 0, 0, 0, 0, 0, 0,
           '0', 0, 0, 0, 0, 0, '',
           '', '', '', '0', '0', '0', '0', '0', '0', '0', '0',
           '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'
           );
  end loop;
  commit;
end;

------------------
declare
coun number(16);
one number(5);
aa  varchar(1);
bb varchar(1);
begin
coun:=10000000;
one:=1001;
  aa:='a';
  bb:='1';
  for n in 1..coun loop
 
  if mod(n,2)=0 then
   one:=1001;
   aa:='a';
    bb:='2';
  end if;
   if mod(n,3)=0 then
   one:=1002;
    aa:='b';
     bb:='3';
  end if;
   if mod(n,5)=0 then
   one:=1003;
    aa:='c';
     bb:='4';
  end if;
  if mod(n,7)=0 then
   one:=1004;
    aa:='d';
     bb:='5';
  end if;
  if mod(n,9)=0 then
   one:=1005;
    aa:='e';
     bb:='6';
  end if;
 
  insert into bbvalues (n||'',one,n,'GX_'||n,bb,aa);
  end loop;
  commit;
end;