Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic Tagname for XMLELEMENT ?

454442Nov 23 2005 — edited Aug 6 2009
How can I create dynamic tagnames for an xmlelement?

For example The department names below are values in the database table
<Departments>
<Accounts>
.....
</Accounts>
<Sales>
......
</Sales>
</Departments>

Here I want to write XSQL to generate the tagnames (Accounts, Sales, etc) at run-time from the table.

select XMLELEMENT (???) ,,,,

Please help

Sanju
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2009
Added on Nov 23 2005
#performance-availability, #xml-db
43 comments
10,133 views