Oracle load XML long character value and replace html escaping («"»)

demo.sql

with t
as
(
select '"ю1"' as dummy from dual
)
select                                     
  dbms_xmlgen.convert(xmlagg (
    xmlelement (
      e,                                      
        t.dummy
      , '.').extract('//text()') ).getclobval(),1) as col_v
from t;