Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Data Types and Expressions > Literal Row >

Literals of an Unnamed Row Type

To specify a literal value for an unnamed ROW type, introduce the literal row with the ROW constructor; you must enclose the values between parentheses. For example, suppose that you define the rectangles table as follows:

CREATE TABLE rectangles 
(
   area FLOAT, 
   rect ROW(x INTEGER, y INTEGER, length FLOAT, width FLOAT),
)

The following INSERT statement inserts values into the rect column of the rectangles table:

INSERT INTO rectangles (rect)
   VALUES ("ROW(7, 3, 6.0, 2.0)")
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]