XML - Oracle -将员工详细信息合并为一条xml输出记录的语法

SELECT XMLELEMENT("Employee",
           XMLFOREST(e.employee_id AS "EmployeeID",
                     e.first_name AS "FirstName",
                     e.last_name AS "LastName",
                     e.email AS "Email",
                     d.department_name AS "Department"),
           XMLAGG(XMLELEMENT("Phone",
                   XMLFOREST(p.phone_number AS "PhoneNumber",
                             p.phone_type AS "PhoneType")))
         )
FROM employees e
JOIN departments d ON e.department_id = d.department_id
LEFT JOIN phones p ON e.employee_id = p.employee_id
GROUP BY e.employee_id, e.first_name, e.last_name, e.email, d.department_name;