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;