SELECT
replace(replace(xml2clob(xmlagg(xmlelement(NAME A, wdd.CASE_NUMBER||','))),'<A>',''),'</A>','') AS CASE_NUMBER
FROM WMS_DECLARE_DETAIL wdd
其中:NAME A 要与 ‘’ 相同 ,wdd.CASE_NUMBER 为字段,也可以加上GROUP BY 进行分组
SELECT
replace(replace(xml2clob(xmlagg(xmlelement(NAME A, wdd.CASE_NUMBER||','))),'<A>',''),'</A>','') AS CASE_NUMBER
FROM WMS_DECLARE_DETAIL wdd
其中:NAME A 要与 ‘’ 相同 ,wdd.CASE_NUMBER 为字段,也可以加上GROUP BY 进行分组