Hi
I am an oracle developer and wish to generate XML using stylesheets and not ||'<'|| etc e.g. I have a table called channel with channel_name and channel_code. I want the data from my table to appear in the tags.

My current stylesheet looks like this

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xdb="http://xmlns.oracle.com/xdb"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<xsl:output method="xml"/>
<xsl:template match="/">
<xsl:for-each select="ROWSET">
<xsl:for-each select="ROW">
<xsl:value-of select="CHANNEL_CODE"/>
<xsl:value-of select="CHANNEL_NAME"/>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

and is getting populated by
select channel_code, channel_name from channel
the output is
<?xml version = '1.0'>
NVL01 NL TS 01

but I want
<CHANNEL_CODE>NVL01</CHANNEL_CODE>
<CHANNEL_NAME>NL TS 01</CHANNEL_NAME>

Any ideas how the stylesheet can be changed?