阅读背景:

oracle 制造数据1000万条

来源:互联网 
declare
i number;
begin
  for i in 1..10000000 loop
if i < 5000000 then 
    if  i < 4000000 then 
        if  i < 3000000 then 
            if  i < 2000000 then 
                if  i < 1000000 then --1 ~~ 1000000
                    insert into tt_part_bkm values ('123456231234567812345678'+i, '6GD123222', '1', 

'zhangwei', '完美世界', 2014, 11, 223, 230, 230);   
                else --1000000 ~~ 2000000
                    insert into tt_part_bkm values ('123452381234567812345678'+i, '7GD123777', '2', 

'zhangyan', '第九城市', 2014, 22, 200, 230, 230);
                end if;     
            else --2000000 ~~ 3000000
                insert into tt_part_bkm values ('123452381234567812345678'+i, '5QD166656', '3', 

'limingzhe', '网易', 2014, 3, 210, 340, 500);
            end if;    
        else --3000000 ~~ 4000000
            insert into tt_part_bkm values ('123456231234567812345678'+i, '5FD144456', '4', 

'changxing', '大众', 2014, 1, 230, 250, 270);
        end if;   
    else --4000000 ~~ 5000000
        insert into tt_part_bkm values ('123452381234567812345678'+i, '51D11116', '5', 'lihui', '宽

文', 2014, 17, 189, 210, 230);
    end if;
else --5000001 ~~~ 10000000
     --insert into tt_part_bkm values ('1234567812345678123456781234567'+i, '5GD123456', '1', 

'zhangwei', '移动', 2014, 23, 200, 210, 230);
    if  i < 9000000 then 
        if  i < 8000000 then 
            if  i < 7000000 then 
                if  i < 6000000 then --5000000~~6000000
                    insert into tt_part_bkm values ('123452381234567812345678'+i, '0GD123T56', '6', 

'mazan', '百度', 2014, 16, 177, 210, 230);   
                else --6000000~~7000000
                    insert into tt_part_bkm values ('123423781234567812345678'+i, '533123356', '7', 

'dingran', '当当', 2014, 15, 178, 210, 230);
                end if;     
            else --7000000~~8000000
                insert into tt_part_bkm values ('123452381234567812345678'+i, '5GT123455', '8', 

'zhangyan', '淘宝', 2014, 13, 200, 232, 250);
            end if;    
        else --8000000~~9000000
            insert into tt_part_bkm values ('123451281234567812345678'+i, '5GQ123453', '9', 

'chenping', '阿里巴巴', 2014, 13, 200, 260, 280);
        end if;   
    else --9000000~~10000000
        insert into tt_part_bkm values ('123453331234567812345678'+i, '5G2123451', '10', 'xuli', '支

付宝', 2014, 20, 189, 211, 230);
    end if;
end if;
end loop;
end;declare
i number;
begin
  for i in 1..10000000 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: