1. Oracle AI Vector Search User's Guide
  2. Use SQL Functions for Vector Operations
  3. Constructors, Converters, Descriptors, and Arithmetic Operators
  4. Aggregate Functions

Aggregate Functions

The aggregate functions SUM and AVG can be applied to a series of vectors dimension-wise.

  • AVG
    The AVG function takes a vector expression as input and returns the average as a vector with format FLOAT64.
  • SUM
    The SUM function takes a vector expression as input and returns the sum as a vector with format FLOAT64.

Parent topic: Constructors, Converters, Descriptors, and Arithmetic Operators