SQL & PL/SQL

Hi

I have this bit of code

SELECT xmlagg(
 xmlelement("tr", xmlattributes(d.deptno as "dept"),
  xmlforest(
   e.ename as "td",
   d.dname as "td"
  )
 )
).getclobval()
FROM scott.emp e 
     JOIN scott.dept d ON d.deptno = e.deptno
WHERE e.deptno = 20
;

What would do I need to do to add another attribute to the TR xml element? for example if I wanted to add in the "JOB" to a custom attribute.

Edited by: Alistair Laing on Aug 4, 2010 11:38 AM