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


Related articles: