The value for a multiple column is an aggregate. An aggregate consists of one or more elements called occurrences. The number of occurrences must be between 1 and 255 and must correspond to the dimension of the multiple column. Values in multiple columns are referred to as multiple values; values in atomic columns are referred to as atomic values (or simply as values).
aggregate ::= <{ value | NULL }, . . . >
value
Value of the occurrence.
NULL
NULL value for the occurrence.
If you set elements of the multiple column to the NULL value with INSERT or UPDATE and the subsequent elements are not null, the non-NULL values in the multiple columns are moved to smaller position numbers and the NULL values are entered after all the non-NULL values.
Example
You can use INSERT to assign values to the numeric multiple column COLOR_TAB with three elements:
INSERT INTO color_tab (rgb(1..3)) VALUES (<0.88,NULL,0.77>)
The multiple column then contains the multiple value:
<0.88,0.77,NULL>