After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed in this
presentation was that the type cannot self-reference. Neither direct nor indirect.
A table like the emp table cannot be expressed as an object type. The table has a column mgr which is a reference to another employee.
So I tried something like this:
TYPE emp_t AS OBJECT ( empno number(4) , ename (more...)