hi
I have a XML stored in a table like below in a xmltype column
<pubDat>
<bNumber>string</bNumberr>
<fld>string</fld>
<dbInstance>string</dbInstance>
</publicationData>
I would like to replace the word 'string' into respective value . Kindly help me out