日期:2014-05-17  浏览次数:20940 次

批量数据插入
[code=SQL][/code]
declare 
idss int :=10402;
ids int :=11102;
begin 
loop 
exit when ids<12884;
insert into cp_org_owner(id,oo_org_id,oo_owner_id) values(idss,10000,ids);
ids:=ids+1;
idss:=idss+1;
end loop;
end;

------解决方案--------------------
insert into cp_org_owner(id,oo_org_id,oo_owner_id) values(idss,10000,ids);
commit;
------解决方案--------------------
exit when ids<12884; 改 exit when ids>12884;试试