Aggregate. Concatenates all the XML values in the group and produces a single value.
xmlagg ( value )
| value | The XML value represented as a string. |
The function, which can be used only in aggregate streams or with event caches, returns a xmltype. Note that the xmltype cannot be stored directly in a record. To store the xml in the record you need to apply the xmlserialize function to convert the xmltype into a string.
xmlagg ( xmlparse (stringCol) )