Mega Code Archive

 

Categories / Oracle PLSQL / Object Oriented Database

 

Build data type with another user type

SQL> create or replace type address_type as object   2  ( city    varchar2(30),   3    street  varchar2(30),   4    state   varchar2(2),   5    zip     number   6  )   7  / SQL> create or replace type person_type as object   2  ( name             varchar2(30),   3    dob              date,   4    home_address     address_type,   5    work_address     address_type   6  )   7  / Type created. SQL> create table people of person_type   2  / Table created. SQL> SQL> select sys_nc_rowinfo$ from people; no rows selected SQL> SQL> drop table people; Table dropped. SQL> SQL>