Purpose
The XMLCONCAT function takes a series of XMLType instances as input, concatenates a series of elements from each row, and returns the concatenated XMLType sequence.
Syntax
XMLCONCAT (XMLType_instance [, XMLType_instance ]...)
Parameters
| Parameter | Description |
|---|---|
| XMLType_instance | One or more XML instances to be passed in. |
Return type
The concatenated sequence of XMLType.
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>