17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure whq_henkel is
cursor cur_whq(vv_itemcode in varchar2) is
select store_id
from tmp_whq_henkel_godeep
where itemcode = vv_itemcode
and wt03 > 0;
str varchar2(2000);
l_result varchar2(1000);
begin
for i in 2 .. 9 loop
for cur_whq_v1 in cur_whq('K00' || i) loop
str := 'update tmp_whq_henkel_godeep set whq' || to_char(i) || '=1 ' ||
'where store_id =' || cur_whq_v1.store_id ||
' and itemcode = ''K001''';
execute immediate str;
end loop;
end loop;
commit;
end;