Last post Jan 28, 2019 05:35 AM by Wei Zhang
Jan 27, 2019 07:02 AM|20141113|LINK
i have oracle column defined as xmltype with following data store in column. i don't know how to update xml node with property value.
define as xmltype in oracle table column.
my sql is as below:
how to update <a3> node with m=2 value from 20181231 to 20181230
Jan 28, 2019 05:35 AM|Wei Zhang|LINK
According to your description, I suggest you to use updateXML() function to update the table data which is defined as xmltype. You could write as below
update table set myxml=updateXML(myxml,'//a3[@m="2"]/text()','20181230')
To learn the updateXML and other function like insert ,delete, you could follow the link as below , I hope it could help you.