I am wondering if there is a generic conversion utility which canconvert the resultset in the Hierarchical XML format based on the XMLDTD.
If you are working with oracle then there is goodarticle in oracle magzine (last) which addrsses urneedotn.oracle.com/.../o63dev_trends.htmllink to the soft copy of the article