2008-06-28 15:45:23 / Oracle开发
declarecursor p isselect aid,sum(gr+corr+reqty)fromruku where rundate>sysdate-2group by aid;d1 number(7);d2 number(15,2);beginopen p;loopfetch p into d1,d2;exit when p%notfound;update jxc set count_qty=count_qty+d2where aid=d1;commit;end loop;close p;end;/这段代码不知道错哪里了,总报错
查看(538)
评论(22)