Merging XML Document

[tabreaz]

Hi everyone,

I have a table with following structure

SrcCode Char(5),
DestCode Char(5),
XMLDoc XMLType.

I have a requirement to merge all the XML documents with same destCode under one parent tag.

The contents of XMLDoc column is:

         <XMLDoc>
                <Node1> </Node1>
                <Node2> </Node2>
         </XMLDoc>

I want the result in following format

<Documents>
       <XMLDoc></XMLDoc>
       <XMLDoc></XMLDoc>
</Documents>

I try the following query but it does not provide me required results

Select XMLElement("ParentNode", XMLDoc)
from XMLDocs;

but the query returns like

<Documents> <XMLDoc></XMLDoc> </Documents>
<Documents> <XMLDoc></XMLDoc> </Documents>