select xmlelement("root",xmlagg(xmlforest(xmlforest(
t.fseq, replace(WMSYS.WM_CONCAT(t.fdptnm),',','/') fdptnm
) TBL))).getclobval()
from pf_tbs_applydpt t
group by t.fseq;
一个fseq对应的fdptnm 有多个值,需要
fseq fdptnm
1 a/b/c
t.fseq, replace(WMSYS.WM_CONCAT(t.fdptnm),',','/') fdptnm
) TBL))).getclobval()
from pf_tbs_applydpt t
group by t.fseq;
一个fseq对应的fdptnm 有多个值,需要
fseq fdptnm
1 a/b/c