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;