REF type for an object reference

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> CREATE TABLE my_ref (
  2     id INTEGER PRIMARY KEY,
  3     e_ref REF t_person SCOPE IS emp
  4  );

Table created.

SQL>
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>
SQL> INSERT INTO my_ref (id,e_ref) VALUES (1,(SELECT REF(e) FROM emp e WHERE e.id = 1));

1 row created.

SQL>
SQL> SELECT * FROM my_ref;

        ID E_REF
----------------
         1
SQL>