Search code examples
oracle-databaseoracle11gxmltype

Oracle updateXML - What is the text() for?

When I'm using the Oracle updateXML()-Function, I have to address the path to the attribute which I'm trying to update (e.g. '/supplier/companyName/text()', 'Some Company Ltd').

OK, I'm fine with that. But what I actually doesn't understand is the text(). It seems that it is a function. Is that correct?

But what else is possible to use there?

Solution

  • Here's a pretty good explanation of the usage of text():

    In the case of updateXML() I think it makes sense to use it because of what you want the resulting update to look like.