DBMS_XMLSTORE SQL functions


How to Modify XML Data?

DBMS_XMLSTORE SQL functions is used for to replace, insert, and delete XML data without replacing the entire surrounding XML document. This means that you can perform piecewise manipulation operations on an XML document by using SQL functions.

You use the following SQL functions:
updateXML() to replace XML nodes of any kind insertChildXML(), insertXMLbefore(), and appendChildXML() to insert XML data deleteXML() to delete XML data

The SQL functions insertChildXML(), insertXMLbefore(), and appendChildXML() can perform updates that are more localized than with updateXML(), thereby greatly improving performance and making source code clearer and more concise.

Do not use the updateXML() function to insert or delete XML data by replacing a parent node in its entirety. Although this works, it is less efficient than using one of the other available functions, which perform more localized updates.

No comments:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...