<div>
There are several ways to deal with this task. Have a look here:<br />
<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions205.htm" rel="ugc">https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions205.htm</a><br />
<a href="https://odieweblog.wordpress.com/2012/06/19/how-to-update-xml-nodes-with-values-from-same-doc/" rel="ugc">https://odieweblog.wordpress.com/2012/06/19/how-to-update-xml-nodes-with-values-from-same-doc/</a><br />
<a href="http://www.java2s.com/Code/Oracle/XML/UsetheUPDATEXMLfunctiontochangeelementvalue.htm" rel="ugc">http://www.java2s.com/Code/Oracle/XML/UsetheUPDATEXMLfunctiontochangeelementvalue.htm</a><br />
<br />
With the proper XPath expression, you should be able to update the XML column easily ;-)
</div>


There are several ways to deal with this task. Have a look here:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions205.htm [https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions205.htm]
https://odieweblog.wordpress.com/2012/06/19/how-to-update-xml-nodes-with-values-from-same-doc/ [https://odieweblog.wordpress.com/2012/06/19/how-to-update-xml-nodes-with-values-from-same-doc/]
http://www.java2s.com/Code/Oracle/XML/UsetheUPDATEXMLfunctiontochangeelementvalue.htm [http://www.java2s.com/Code/Oracle/XML/UsetheUPDATEXMLfunctiontochangeelementvalue.htm]

With the proper XPath expression, you should be able to update the XML column easily ;-)

<div>
Hi Alex, Thanks for share this. <br />
<br />
I have found following code for &nbsp;update XML type.<br />
<br />
<b>UPDATE warehouses SET warehouse_spec =<br />
&nbsp; &nbsp;UPDATEXML(warehouse_spec,<br />
&nbsp; &nbsp;'/Warehouse/Docks/text()',<wbr />4) &nbsp;<br />
&nbsp;--/Warehouse/Docks/text()'<wbr /> I don't understand the 2nd parameter how it use if i want to replace a string with new string/null how can i use it.<br />
&nbsp; &nbsp;WHERE warehouse_name = 'San Francisco';</b><br />
<br />
Thanks!
</div>


Hi Alex, Thanks for share this.

I have found following code for  update XML type.

UPDATE warehouses SET warehouse_spec =
   UPDATEXML(warehouse_spec,
   '/Warehouse/Docks/text()',4)  
 --/Warehouse/Docks/text()' I don't understand the 2nd parameter how it use if i want to replace a string with new string/null how can i use it.
   WHERE warehouse_name = 'San Francisco';

Thanks!

#Hadoop #Oracle_DB  #UNIX beginner

MIHIR KAR

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm facing error with below table and data please help.<br />
<br />
I want to replace the XML string &lt;to_disposition&gt;NULL &nbsp;with &lt;/to_disposition&gt;.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396387/tbl1.PNG" target="_blank" title="Table contain SYS.XMLTYPE column (16 KB)"><img alt="Table contain SYS.XMLTYPE column" class="file-block lazyload" style="max-width: 322px;" data-src="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396387/tbl1.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396388/xml.PNG" target="_blank" title="Want to replace <to_disposition>NULL with </to_disposition> (160 KB)"><img alt="Want to replace <to_disposition>NULL with </to_disposition>" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/10_w43/800_1396388/xml.PNG" /></a><br />
Please let me know if you need more details.<br />
<br />
Thanks,<br />
<br />
Mihir
</div>
</div>


Want to replace <to_disposition>NULL with </to_disposition>

xml.PNG

tbl1.PNG

Hi Experts,

I'm facing error with below table and data please help.

I want to replace the XML string <to_disposition>NULL  with </to_disposition>.



Please let me know if you need more details.

Thanks,

Mihir

How to replace XML string in DB!

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.