Insert value to a specific column for an object table with insert...select statement : Insert « Object Oriented Database « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Object Oriented Database
  3. Insert

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








Related examples in the same category

1.INSERT Values into a Table with the Column Type in It
2.INSERT Values into a Table that Contains Row Objects (TCRO)
3.One-step INSERTs into an object table
4.Insert data into an object table
5.Insert value with type variable
6.Insert value to an objec table as normal table
7.Insert inherited object
8.Use table function in insert statement for a user-defined type column
9.Object table insert
10.Insert value to one column in an object table