Rows and collections

Rows and collections are composite values that consist of one or more elements.

The information in these topics apply only if your database server is HCL® OneDB®.

You can use the SELECT, UPDATE, INSERT, and DELETE statements to access an entire row or collection. However, these SQL statements do not let you access an element that is in a row or collection. To access an element, you need to retrieve the row or collection and then access the element from the local copy of the row or collection.

For more information about rows and collections, see the HCL OneDB Guide to SQL: Reference, and HCL OneDB User-Defined Routines and Data Types Developer's Guide.