I want the output as:

<rowset>
<year 2002>
<date 07/01>
elements
</date 07/01>
<date 07/02>
elements
</date 07/02>
.................................
</year 2002>
<year 2003>
<date 01/01>
elements
</date 01/01>
<date 01/02>
elements
</date 01/02>

...............................
</year 2003>
''''''''''''
</rowset>


I will use xsql to retrive data from Oracle and get the output in the above XML format. How to do this?

Thanks,

Pam