I want to do something like this :- I Defined an EmployeeType with the following
CREATE TYPE EmployeeType as OBJECT
MEMBER FUNCTION get_address RETURN VARCHAR2
and it compiled successfully. I was told to create a DepartmentType and I did that with the following command;
CREATE TYPE DepartmentType as OBJECT
manager REF EmployeeType
It also compiled successfully but when I tried joining the two tables using sql command there was no information displayed, because the two tables were not properly related.
The problem here is how to relate the manager in the DepartmentType to the emp_id in the EmployeeType.I have not related the two properly. Am really confused about how to do the reference between the manager and the emp_id. Am stocked and I seriously need help.