xml format
How does one achieve an xml file with proper grouping shown in the xml file ?
my need: select deptno,ename,empno from emp group by deptno. I would like to have it something like
<deptno> 10 </deptno>
<ename> testname1 </ename>
<empno> testempno1 </testempno1>
<ename> testname2</ename>
<empno> tesempno2</empno>
..<deptno2>20</deptno>......
ex: the following snip is from bip report designer's guide. Notice it was grouping by each supplier Name.
<SUPPLIER>
 <NAME>My Supplier</NAME>
 <INVOICES>
  <INVOICE>
   <INVNUM>10001-1</INVNUM>
   <INVDATE>1-Jan-2005</INVDATE>
   <INVAMT>100</INVOICEAMT>
