Category: XML
XML and xsql
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