Database Tuning (MOSC)

MOSC Banner

Problem with creating XML

edited Mar 26, 2009 6:34AM in Database Tuning (MOSC) 1 commentAnswered
Hi,


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",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center