How to remove ELEMENTs from XMLELEMENT in Oracle 11g

Question

I am trying to get rid of few changes while using XMLELEMENT. Below is an example:

SELECT XMLAGG(XMLELEMENT(E, ' ---- test using & (Ampersand) and '' (Apostrophe) ---- ')).EXTRACT('//text()').GETCLOBVAL() FROM DUAL;

It produces a HUGECLOB:

-- test using &amp; (Ampersand) and &apos; (Apostrophe) --

But I need the exact content:

-- test using & (Ampersand) and ' (Apostrophe) --

In XMLELEMENT its mandatory to pass Element Name (any character or string)

Is there any other option ?

Thanks in advance.

score 1 · Accepted Answer · edited May 23 '17 at 12:06

1

Found related answer:

Use of utl_i18n.unescape_reference

If you have anymore better option please reply. Thanks

edited May 23 '17 at 12:06

Community

answered Sep 16 '16 at 11:22

user3360094

1 Answers1