Mega Code Archive

 

Categories / Oracle PLSQL / Object Oriented Database

 

Insert value to a specific column for an object table with insert select statement

SQL> SQL> create or replace type address_type   2    as object   3    ( city    varchar2(30),   4      street  varchar2(30),   5      state   varchar2(2),   6      zip     number   7    )   8  / Type created. SQL> create or replace type person_type   2    as object   3    ( name             varchar2(30),   4      dob              date,   5      home_address     address_type,   6      work_address     address_type   7    )   8  / Type created. SQL> SQL> SQL> create table people1 of person_type   2  / Table created. SQL> SQL> SQL> insert into people1(name)   2   select rownum from all_objects; 12213 rows created. SQL> SQL> drop table people1; Table dropped. SQL> SQL> drop type person_type; Type dropped. SQL> drop type address_type; Type dropped. SQL> --