Experts... How do I replace the value in an element of xmltype. ex: I have an xmltype and which has the following structure
<fstype> 2 </fstype>
If I want to replace the element <arp> with a value of 5 after the xml is built how do I do it.
I saw that there isa function UpdateXML in Oracle. Not sure how to use it.