D
--------------------------------------------------
0000280209A656BEEF11B811D1AD5B0060972CFBA8A656BEEE
11B811D1AD5B0060972CFBA8008000C10000
0000280209A656BEF011B811D1AD5B0060972CFBA8A656BEEE
11B811D1AD5B0060972CFBA8008000C10001
SQL> insert into emp select 'Mike Ault',1, REF(d) from dept d
SEE CODE DEPOT FOR FULL SCRIPTS
SQL> /
1 row created.
SQL> select * from emp;
ENAME ENUMBER
----------------------------------------------
---------------------------------
Mike Ault
1
EDEPT
------------------------------------------------------------
0000220208A656BEEF11B811D1AD5B0060972C
FBA8A656BEEE11B811D1AD5B0060972CFBA8
SQL> select ename,enumber,deref(edept) from emp;
ENAME ENUMBER
----------------------------------------------
--------------------------------
DEREF(EDEPT)(DNAME,
ADDRESS)
------------------------------------------------------------------
Mike Ault 1
DEPT_T('Home', '5055 Forest
Run')
SQL> spool off
