Collection data type
A collection data type is a set of elements of another, single data type. Collection elements can never be null.
You can overload existing user-defined routines and built-in routines to work on your collection data type. You can also define custom support routines for your collection data type. See Create routines for instructions.
Property | Default value | Description |
---|---|---|
Type | None | The data type that makes up the collection.
For more information, see Valid element data types. |
Constructor | None | The type constructor: LIST, MULTISET, or SET.
For more information, see Type constructors. |
See the HCL OneDB™ Guide to SQL: Tutorial for general information about collection data types.