[C#] sql -> xml -> object

http://docs.oracle.com/cd/B19306_01/appdev.102/b14259/xdb13gen.htm

SELECT A.*,
        CURSOR(SELECT B.*
               FROM EMPLOYEE B
               WHERE B.DEPT_ID = A.ID) as EMPLOYEE
FROM DEPT A