XMLSequence with lowercase tags
850838Mar 28 2011 — edited Mar 31 2011hi everyone
i'm working on a procedure to export some data as XMLSequence. the query works, but i'd like to have some things modified on the way the result looks like:
1.
generated XML-tags are UPPERCASE, how can i force oracle to generate lowercase XML-tags?
postprocessing is no option.
2.
lists are exported this way:
<NAMEOFELEMENT>
<NAMEOFELEMENT_ROW>
<NAMEOFELEMENT_ROW>
<NAMEOFELEMENT_ROW>
</NAMEOFELEMENT>
but i'd like oracle to use the following naming:
<NAMEOFELEMENT_LIST>
<NAMEOFELEMENT>
<NAMEOFELEMENT>
<NAMEOFELEMENT>
</NAMEOFELEMENT_LIST>
means, instead of adding "_ROW" to the name of each data row in the export, the enclosing XML-tag should have a "_LIST" added to it's name.
the outermost xml-element is named <ROW>, i was able to instruct oracle to rename it to whatever i need, using the additional XMLFormat('MYNAME'), so i'm confident there're more ways to configure the generated XML-output.