oracle数据库造测试数据,oracle创办测试数据

当前位置:我的异常网» 数据库 » oracle创办测试数据

oracle创办测试数据

www.myexceptions.net  网友分享于：2013-07-16  浏览：0次

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;

文章评论