Dynamic XMLelement generation

From: EliR <elire_at_amdocs.com>
Date: 2 Jun 2005 07:25:19 -0700
Message-ID: <1117722319.549273.59150@g49g2000cwa.googlegroups.com>

Hi ,

I have a very small question regarding Xmlelement function , can the XMLelement tag name can be generated dynamically (base on CASE expression / decode).
I am using the new XSQL capabilities in oracle 9i and i failed to do it

This is very simple case , I would like to know the concept :

SQL> select table_name from user_tables;

TABLE_NAME

---

DBA_CONSTRAINTS
DBA_INDEXES
DBA_IND_COLUMNS
DBA_LOBS
DBA_SEQUENCES
DBA_SOURCE
DBA_TABLES
DBA_TAB_COLUMNS
DBA_TRIGGERS
DBA_VIEWS

OPCONFIG
PLAN_TABLE select CASE WHEN table_name='DBA_CONSTRAINTS' THEN xmlelement(name "DBA_LOBS") ELSE xmlelement(name "DBA_CONSTRAINTS") END from user_tables;
And this is what i get

CASEWHENTABLE_NAME='DBA_CONSTRAINTS'THENXMLELEMENT(NAME"DBA_LOBS")ELSEXMLELEMENT(NAME"DBA_CONSTRAINTS")END

---

<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
<DBA_LOBS></DBA_LOBS>
Received on Thu Jun 02 2005 - 09:25:19 CDT