xml format

Aug 25, 2011 9:31AM

This might be a stupid question but plz bear with me since I can't finad any answers.

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

<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>

Oracle Reports (MOSC)