select
m.deptid,
xmlelement("department",
xmlelement("dept",m.deptid),
xmlagg(xmlelement("emp",n.empid),xmlelement("love",n.empname))
)
test from employee_test2 n,department_test2 m
where n.deptid=m.deptid
group by m.deptid
When i execute above query it throws error
When i remove this xmlelement("love",n.empname it execute successfully
Can someone help me in this
