OE.DEPTVIEW (view)
wikibot
View | OE.DEPTVIEW |
Source
CREATE OR REPLACE VIEW OE.DEPTVIEW AS SELECT xmlelement("Department", xmlForest(department_name, location_id), (SELECT sys_xmlagg(xmlelement("Employee",xmlForest(last_name, job_id,manager_id, hire_date, salary, commission_pct) ), xmlformat('EmployeeList')) FROM employees e WHERE e.department_id = d.department_id )) xml FROM departments d
References
Dependency Type | Object Type | Referenced Object |
Select | Table | HR.DEPARTMENTS |
Select | Table | HR.EMPLOYEES |