How to parse(append) value to existing xml file in oracle?

Question

How to parse(append) value to existing xml file in oracle??? (I have standard fields in my xml file, i want to change that field value dynamically from oracle database).

Thank you.

Answer 1

SELECT UpdateXML(XMLTYPE('d'), '/a/b/text()', 'c') FROM dual;