declare
cursor cc is select id,distinct productcode,element from TKL_PRODUCT_CONTENT where state =1;
ccrec cc%rowtype;
begin
for ccrec in cc
loop
update TKL_PRODUCT_CONTENT_VICE set id =ccrec.id where productcode = ccrec.productcode and element = ccrec.element
end loop;
end;
游标的使用
最新推荐文章于 2020-05-25 17:22:52 发布