Hello
Can I use XMLELEMENT inside XMLFOREST ? I am trying to achieve below structure
<IDENTIFIER>zzzz</IDENTIFIER>
<MA>
<TITLE>pppp</TITLE>
<DOB>YYYY-MM-DD</DOB>
<MA_CAD>
<POSTCODE>xxxx</POSTCODE>
</MA_CAD>
</MA>
Now to achieve the above structure I have written
SELECT
XMLELEMENT("IDENTIFIER",X.Value1),
XMLELEMENT("MA",
XMLFOREST(X.value2 "TITLE",
X.value3 "DOB",
XMLELEMENT("MA_CAD",
XMLFOREST(X.value 4 "POSTCODE"))))
FROM TABLE PQR X;
The above sql query throws an error. How do we rectify it and get the above XML file. Can't we use XMLELEMENT inside XMLFOREST?