<pre lang="xml"><?xml version="1.0" encoding="WINDOWS-1252"?> <Test> <Selection ID="A"> <Child ID="1"> <Name/> <DOB/> </Child> <Child ID="2"> <Name/> <DOB/> </Child> </Selection> <Selection ID="B"> <Child ID="1"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> <Child ID="2"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> </Selection> </Test> I am having above above exising XMLtype data type in Oracle Database. I want to update the xml like below, <pre lang="xml"><pre lang="xml"><?xml version="1.0" encoding="WINDOWS-1252"?> <Test> <Selection ID="A"> <Child ID="1"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> <Child ID="2"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> </Selection> <Selection ID="B"> <Child ID="1"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> <Child ID="2"> <Present>Yes</Present> <Name/> <DOB/> <Address>Tests</Address> </Child> <Selection> </Test>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)