Przykłady na schemacie Oracle HR

select sys.dbms_xmlgen.getxml('select e.first_name || '' '' || e.last_name as full_name, d.manager_id as manager_id, d.department_name, l.city, cursor(select em.first_name || '' '' || em.last_name as full_name, j.job_title from hr.employees em, hr.jobs j where em.manager_id = d.manager_id and em.job_id = j.job_id) as employee from hr.departments d, hr.employees e, hr.locations l where d.location_id = l.location_id and (l.city like ''' || ? ||  ''') and e.employee_id = d.manager_id') as xml from dual