首页 › Oracle › oracle创建测试数据

270585784 发表于 2013-1-14 08:56:10

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);
aavarchar(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;

查看完整版本: oracle创建测试数据