HOWTO: use table column value as tag name in XMLElement (9iR2)
28499Oct 27 2006 — edited Nov 6 2006Hi,
maybe what I'm trying to do simply does not work, but here is my sample:
select XMLElement(DUMMY, DUMMY).getClobVal( ) as SAMPLE
from DUAL;
returns the following XML
<DUMMY>X</DUMMY>
But what I want to get is
<X>X</X>
because "X" is the value of column "DUMMY" for table DUAL
Is there a way to do this in PL/SQL XML-DB in Oracle 9i-R2?
TIA,
Stefan