Oracle: how to use updateXML to update multiple nodes in a document?
Posted
by Alessandro Vernet
on Stack Overflow
See other posts from Stack Overflow
or by Alessandro Vernet
Published on 2009-01-01T23:29:29Z
Indexed on
2010/04/27
2:53 UTC
Read the original article
Hit count: 328
I can write:
update my_table
set xml = updateXML(xml, '/a/b', '1')
where document_id = 123
Now what if in the same update query I also want to set /a/c to 2 (in addition /a/b to 1)? I am tempted to write:
update my_table
set
xml = updateXML(xml, '/a/b', '1'),
xml = updateXML(xml, '/a/c', '2')
where document_id = 123
But this give me a "ORA-00957: duplicate column name". Any suggestion on how to do this?
© Stack Overflow or respective owner
