I have a table named "device" which contains a column named as "XMLdoc" of CLOB datatype. I want to update the Value field.
Name="DropDirectory" Value=""
/*Following is the sample XML:*/
<?xml version="1.0" encoding="UTF-8"?>
<Attributes>
<Attribute DataType="Text-40" DisplayName="PrinterAlias"
IsNotDeletable="Y" Modifiable="Y" Name="PrinterAlias" Value="QALABHP"/>
<Attribute DisplayName="PrintServerHostName"
Name="PrintServerHostName" Value="zzzzz"/>
<Attribute DisplayName="PrintServerPort" Name="PrintServerPort" Value="2723"/>
<Attribute DataType="Text-40" DisplayName="DropDirectory"
IsNotDeletable="Y" Modifiable="Y" **Name="DropDirectory" Value=""/>
</Attributes>
You didn't specify your Oracle version. I'll assume it's 11g.. (Note : If you are using 12c, you should probably use XQuery).
Here I update the Value attribute to new_value.
Result (CLOB):