SELECT replace(replace(xml2clob(xmlagg(xmlelement(NAME a, BRANCH_COMPANY_ID||','))),'<A>',''),'</A>','') AS branchIds FROM TZ_CUST_BRANCH_COMPANY a
pdf的处理jar:E:\maven\repository\com\itextpdf\itextpdf\5.4.1\itextpdf-5.4.1.jar
SELECT replace(replace(xml2clob(xmlagg(xmlelement(NAME a, BRANCH_COMPANY_ID||','))),'<A>',''),'</A>','') AS branchIds FROM TZ_CUST_BRANCH_COMPANY a
pdf的处理jar:E:\maven\repository\com\itextpdf\itextpdf\5.4.1\itextpdf-5.4.1.jar