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, Inserting into Row-Type Columns (IDS), 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. Figure 350 shows the 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;