Retrieving array values

Retrieving array values can be done in multiple ways.

The following topics show you how to retrieve values from arrays:

Retrieving array values using an index
Retrieving array element values can be done directly by referencing the array and specifying a sub-index value.
Retrieving the number of array elements
Retrieving the number of array elements in a simple array can most easily be done by using the CARDINALITY function and retrieving the maximum allowed size of an array can be done using the MAX_CARDINALITY function.
Retrieving the first and last array elements (ARRAY_FIRST, ARRAY_LAST functions)
Retrieving the first and last elements in a simple array can most easily be done by using the ARRAY_FIRST and ARRAY_LAST functions.
Retrieving the next and previous array elements
Retrieving the next or previous elements in a simple array can most easily be done by using the ARRAY_PRIOR and ARRAY_NEXT functions.

Parent topic: Ordinary array data type