如何从ORACLE中倒出非缺省的XML文件

[distliu]

缺省情况下,从ORACLE中倒出的XML文件格式是:
<ROWSET>
<ROW num="1">
<a>fordf0</a>
<b>week0</b>
<c>2-00:00</c>
<d>2-23:59</d>
</ROW>
</ROWSET>
要想改为
<ROWSET>
<ROW num="1">
<a>fordf0
<b>week0
<c>2-00:00</c>
<d>2-23:59</d>
</b>
</a>
</ROW>
</ROWSET>
怎么做

[saucer]

do not know how to change the output format in Oracle, but you can always use an XSLT stylesheet to transform the data, for example


<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="ROWSET | ROW ">
<xsl:copy>
<xsl:copy-of select="@*" />
<xsl:apply-templates select="*[position()=1]"/>
</xsl:copy>
</xsl:template>

<xsl:template match="a | b">
<xsl:copy>
<xsl:copy-of select="@*" />
<xsl:value-of select="text()" />
<xsl:apply-templates select="following-sibling::*[position() = 1]" />
</xsl:copy>
</xsl:template>

<xsl:template match="c | d">
<xsl:copy-of select="." />
<xsl:apply-templates select="following-sibling::*[position() = 1]" />
</xsl:template>

</xsl:stylesheet>