In Oracle using xmlelement appear no matter how to change & amp; apos; But this will not happen again in the DB2 asked, hope the great god directions

Another problem is that this time I want to use the replace to replace & amp; apos; Not as shown in figure

CodePudding user response:

Using the xmlagg line string?
Just use the
With t as
(select level as l from dual connect by level & lt;=10)
Select xmlagg (xmlparse (content '"' | | l | | ' ' ', 'wellformed)). Getstringval () from t