Problem with creating XML
I am trying to make XML view from the Oracle database
(OS: Microsoft Windows Server 2003 R2
Installed Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod ).
The select statement looks like this :
SELECT XMLELEMENT(
"MTLF", xmlattributes(SYSDATE as "DateTimeSaved"),
XMLAGG(XMLELEMENT("Type", xmlattributes(ELEMENT_TYPE as "TypeObj"), xml))
)
FROM ( SELECT ELEMENT_TYPE,
XMLAGG(XMLELEMENT("Object", xmlattributes("ID" as "ID"), xml)) xml
FROM ( SELECT MM.ELEMENT_TYPE AS ELEMENT_TYPE,
MM."ID" AS "ID",
XMLAGG(XMLELEMENT(
"LoadData",
xmlattributes(MM.TIME_STAMP as "Date",
MM.P_AVG as "Pavg",
MM.P_MAX as "Ppeak",
MM.Q_AVG as "Qavg",
MM.Q_MAX as "Qpeak",