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