OS & Databade version, Please.
It works for me in 9.2.0.8:
NOTE: the result is [<]ELN[>]1[<]/ELN[>]. I can't seem to get the tabs escaped.Code:SQL*Plus: Release 9.2.0.8.0 - Production on Vie Dic 1 10:45:47 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Conectado a: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production sql> select xmlconcat(xmlelement(eln,1)) from dual; XMLCONCAT(XMLELEMENT(ELN,1)) ------------------------------------------------------------------------- [<]ELN[>]1[<]/ELN[>] sql>
HTH
Cheers.
Carlos.




Reply With Quote