help..

is it possible to do this in Oracle (8 ->):

CREATE TYPE x_t AS OBJECT (

    a y_t
);
/

CREATE TYPE y_t AS OBJECT (

    a x_t
);
/

a more practical example:
an employee mananges a group of employees. i wish to keep these employees in a table:
CREATE TYPE employee_tab AS TABLE OF REF employee;
/

CREATE TYPE employee AS OBJECT (

    id NUMBER,
    name VARCHAR2(30),
    manges employee_tab
);
/

regards, chris. Received on Sun Dec 01 2002 - 21:42:48 CET