Vector Constructors

TO_VECTOR() and VECTOR() are synonymous constructors of vectors. The functions take a string of type VARCHAR2 or CLOB as input and return a vector as output.

• TO_VECTOR

  TO_VECTOR is a constructor that takes a string of type VARCHAR2, CLOB, BLOB, or JSON as input, converts it to a vector, and returns a vector as output. TO_VECTOR also takes another vector as input, adjusts its format, and returns the adjusted vector as output. TO_VECTOR is synonymous with VECTOR.

• VECTOR

  VECTOR is synonymous with TO_VECTOR.

• VECTOR_ORIGIN

  The VECTOR_ORIGIN operator generates a vector in which all dimensions are zero, representing the origin point in an n-dimensional graph.

• VECTOR_RANDOM and VECTOR_RANDOM_PER_ROW

  The VECTOR_RANDOM and VECTOR_RANDOM_PER_ROW operators generate a vector with all dimension values as some random value, representing a random point in an n-dimensional graph.