for o in(select * from TEMPDATA_BIG where c6 is not null)
loop
update TEMPDATA_BIG set c6=(SELECT replace(wmsys.wm_concat(describe),',','→') FROM (
select describe from lbfundefinition connect by prior fid=id start with name=o.c6 order by id))
where c6=o.c6;
end loop;
对于上面的那个代码 是怎么循环的啊oraclefor loop
loop
update TEMPDATA_BIG set c6=(SELECT replace(wmsys.wm_concat(describe),',','→') FROM (
select describe from lbfundefinition connect by prior fid=id start with name=o.c6 order by id))
where c6=o.c6;
end loop;
对于上面的那个代码 是怎么循环的啊oraclefor loop
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货