Nested xmlAgg order by
adam73Jul 7 2003 — edited Jul 7 2003Hi,
i would like to sort (order by) a nested xmlAgg Query but it seems not to work, why ?
My table:
select * from dummy;
NAME
-------------------------
scoot
alice
My Query:
select xmlelement("NAMES", xmlelement("TIMESTAMP", sysdate), (select xmlagg(xmlelement("NAME", name)) from dummy order by name)) from dual;
I get allways the error:
ORA-00907: Rechte Klammer fehlt
(ORA-00907 right parenthesis missing)
Without the "order by"-clause the query works perfectly.
Perhaps sorting nested queries is impossible ?
regards
Adam