Description of insertChildXML.gif follows
Description of the illustration insertChildXML.gif


INSERTCHILDXML inserts a user-supplied value into the target XML at the node indicated by the XPath expression. Compare this function with INSERTXMLBEFORE.

See Also:

Oracle XML DB Developer's Guide for more information about this function
  • XMLType_instance is an instance of XMLType.

  • The XPath_string is an Xpath expression indicating one or more nodes into which the one or more child nodes are to be inserted. You can specify an absolute XPath_string with an initial slash or a relative XPath_string by omitting the initial slash. If you omit the initial slash, the context of the relative path defaults to the root node.

  • The child_expr specifies the one or more element or attribute nodes to be inserted.

  • The value_expr is an fragment of XMLType that specifies one or more notes being inserted. It must resolve to a string.

  • The optional namespace_string provides namespace information for the XPath_string. This parameter must be of type VARCHAR2.


The following example adds a second /Owner node to the warehouse_spec of one of the warehouses updated in the example for APPENDCHILDXML:

UPDATE warehouses SET warehouse_spec =
   '/Warehouse/Building', 'Owner',
   WHERE warehouse_id = 3;

SELECT warehouse_spec FROM warehouses   WHERE warehouse_id = 3;

<?xml version="1.0"?>
  <VClearance>11.5 ft</VClearance>