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