getting column value as tag in xml

[sravanthi]

Hi,

How can we get the column value as tag in xml?

For ex:

My 1st column name is COLOUR and its value is 'BLACK','WHITE' etc..,
2nd column name is LENGHT and its values is 1,2,....etc

I have to generate xml as
<BLACK>
<Value>
1
</Value>
</BLACK>
<WHITE>
<Value>
2
</Value>
<WHITE>

Could anyone suggest how to mention the path for this.

Thanks!