Purpose
The XMLCONCAT function takes one or more XMLType instances as input, concatenates the elements of each row, and returns the concatenated XMLType sequence.
Syntax
XMLCONCAT (XMLType_instance [, XMLType_instance ]...)
Parameters
| Parameter | Description |
|---|---|
| XMLType_instance | One or more XML instances. |
Return value
The concatenated XMLType sequence.
Examples
# Concatenate two XMLType instances.
obclient> select XMLCONCAT(xmltype('<testinfo a="0"> <e1>111</e1> </testinfo>'), xmltype('<testinfo a="1"> <e1>111</e1> </testinfo>')) from dual;
<testinfo a="0"> <e1>111</e1> </testinfo><testinfo a="1"> <e1>111</e1> </testinfo>