Insert rows into typed tables

You can insert rows into a typed table in the same way you insert rows into a table not based on a ROW type.

When a typed table contains a row-type column (the named ROW type that defines the typed table contains a nested ROW type), you insert into the row-type column in the same way you insert into a row-type column for a table not based on a ROW type. The following section, Syntax rules for inserts on columns, describes how to perform inserts into row-type columns.

This section uses row types zip_t, address_t, and employee_t and typed table employee for examples. The following figure shows the SQL syntax that creates the row types and table.

Figure 1: SQL syntax that creates the row types and table.

CREATE ROW TYPE zip_t
(
   z_code    CHAR(5),
   z_suffix  CHAR(4) 
);

CREATE ROW TYPE address_t
(
   street    VARCHAR(20),
   city      VARCHAR(20),
   state     CHAR(2),
   zip       zip_t
);

CREATE ROW TYPE employee_t 
(
   name      VARCHAR(30),
   address   address_t,
   salary    INTEGER
);

CREATE TABLE employee OF TYPE employee_t;