Some details of oracle updating xml node issues
- 2021-12-04 11:37:20
- OfStack
Some nodes are < emali/ > In this way, so directly
update table1 e set e.xxx_xml=updatexml(e.xxx_xml,'/data/contact/email/text()',
'value'
)
where 1=1;
Can't be updated
update table1 e set e.xxx_xml=updatexml(e.xxx_xml,'/data/contact/email',
'<email>'|| 'value' || '<email/>'
)
where 1=1;
So you can update it