Literals for Nested Rows

If the literal value is for a nested row, specify the ROW type constructor for each row level. If you include quotation marks as delimiters, they should enclose the outermost row. For example, suppose that you create the emp_tab table:

CREATE TABLE emp_tab
(
   emp_name CHAR(10),
   emp_info ROW( stats ROW(x INT, y INT, z FLOAT))
);

The following INSERT statement adds a row to the emp_tab table:

INSERT INTO emp_tab VALUES ('joe boyd', "ROW(ROW(8,1,12.0))" );

Similarly, if the row-string literal contains a nested collection, only the outermost literal row can be enclosed between quotation marks. Do not put quotation marks around an inner, nested collection type.

Related Information