Question

Oracle for 循环 修改语句

declare
industrycategorycodes number(30) :=12001;
begin

for i in 1..52 loop
industrycategorycodes :=industrycategorycodes+1;
update Dic_Industrycategory set industrycategorycode=industrycategorycodes where industrycategory_id_parent=440;
end loop;
end;

结果

为什么 Code列不是12001........12052

Answer 1

select 12000+rownum industrycategorycode
from Dic_Industrycategory
where industrycategory_id_parent=440;

追问

我想问的是 如何修改,,,,,

追答

都能给出结果了,更新你还不会吗