Reference column name in an object table : Insert « Object Oriented « Oracle PL/SQL Tutorial

SQL>
SQL>
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  /

Type created.

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> insert into people values ( 'Tom', '15-mar-1965',
  2    address_type( 'Reston', '1 Street', 'Va', '45678' ),
  3    address_type( 'Redwood', '1 Way', 'Ca', '23456' ) );

1 row created.

SQL> /

1 row created.

SQL>
SQL> insert into people(name) select rownum from all_objects;

12663 rows created.

SQL>
SQL> drop table people;

Table dropped.

SQL>
SQL> drop type person_type;

Type dropped.

SQL> drop type address_type;

Type dropped.

SQL>

32.12.Insert
	32.12.1.	Inserting Rows into the Table with object type column
	32.12.2.	Inserting a row of object into an object table
	32.12.3.	Inserting a row into an object table by supplying the values in the same way in a relational
	32.12.4.	INSERT Values into a Table with the Column Type in It
	32.12.5.	Object Relational tables
	32.12.6.	INSERT object instance by calling its constructor
	32.12.7.	Reference column name in an object table
	32.12.8.	Insert value to a table with 'table of custom type' as table column type
	32.12.9.	Reference type constructor in insert statement
	32.12.10.	Use user-defined type in insert statement
	32.12.11.	Insert statement with nested type