instead of this:
i want this:
but I don't see any setting to make DBMS_XMLGEN.GETXMLTYPE do this. I am guessing one of four things:
1. there is a function call for the setting I don't see (undocumented?).
2. I have to use a style sheet to dynamically convert the output as it is generated.
3. Like to @ for Attribute style, there is some other character that can be used in TYPE definitions that will tell the xml generated to use this format
4. I can't use dbms_xmlgen.getxmltype but instead need to use the sql functions like XMLELEMENT.
So who knows? Thanks, Kevin.