批量数据插入
[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;试试
