This chapter describes functions, operators, expressions and methods that operate on either one-dimensional (1-D), multidimensional (n-D), or both ARRAY data types. These functions allow you to perform arithmetic, relational, and aggregate operations on an array in its entirety or on a subset of the elements composing an array.
For information on the ARRAY data type, see "ARRAY/VARRAY Data Type" in SQL Data Types and Literals. For information on creating one-dimensional and multi-dimensional arrays, see "CREATE TYPE (ARRAY/VARRAY Form)" in SQL Data Definition Language Syntax and Examples.
Note: The functions in this chapter are embedded services system functions. For information on activating and invoking embedded services functions, see “Embedded Services System Functions” on page 24.