XML root elements
653816Nov 10 2008 — edited Nov 11 2008Hi i am writing a sql select query to create an xml file.
SELECT
XMLELEMENT("data",
XMLATTRIBUTES('http://smile.mit.edu/shelf/' as "wiki-url",
'SIMILE JFK Timeline' as "wiki-section"),
XMLELEMENT("event",
XMLATTRIBUTES(e.IMP_DATE as "start",
e.NAME||': '|| e.ECCTS as "title",
e.IMP_DATE as "end")
))
from monica_tab2 e;
When this query runs, it appears to show the data tags as elements for every record. I want this to be a root element so that it only appear once for all the events.
Is there any way i can do this? Examples will be appreciated
Thanks
Edited by: Monica B on Nov 10, 2008 7:21 AM