Object Identifiers and Object References

CREATE TYPE t_address AS OBJECT (
    street VARCHAR2(15),
    city VARCHAR2(15),
    state CHAR(2),
    zip VARCHAR2(5)
);
/

CREATE TYPE t_person AS OBJECT (
    id INTEGER,
    first_name VARCHAR2(10),
    last_name VARCHAR2(10),
    dob DATE,
    phone VARCHAR2(12),
    address t_address
);
/


CREATE TABLE emp OF t_person;

SQL> INSERT INTO emp VALUES (
  2     t_person(1, 'Jason', 'Brown', '01-FEB-1995', '999-555-9999',t_address('Main Street', 'Smalltown', 'CA', '12345'))
  3  );

1 row created.

SQL>


SQL> SELECT REF(e) FROM emp e WHERE e.id = 1;

REF(E)
--------------------------------------------------------------------------------

00002802098081B86A299A4A8D8C2670185F026D768B5A6F229A0243928C9B4C0983B38D320040A6420002


SQL>