Oracle For 循环添加数据

 自己亲自使用的,绝对OK

--添加数据
declare i number;
--用for实现
begin
for i in 0 .. 500 loop
insert into cust(custsn,type,code,pwd,provincecode,citycode,partycodetype,partycodevalue,partycitycode,identtype,identnum,name,brand,servicelevel,address)
values(sys_guid(),'01','360123198904010001'+i,'123456','86su','025','100200','100200300','su025','03','3206211992','陈霏','A',1,'中山路328号');
end loop;
end;

原文地址:https://www.cnblogs.com/bruceli-net/p/4798091.html