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

VECTOR_DIMENSION_COUNT

VECTOR_DIMENSION_COUNT returns the number of dimensions of a vector as a NUMBER.

Syntax


Description of vector_dimension_count.eps follows
Description of the illustration vector_dimension_count.eps

Purpose

VECTOR_DIMENSION_COUNT is synonymous with VECTOR_DIMS.

Parameters

expr must evaluate to a vector.

If expr is NULL, NULL is returned.

Example

SELECT VECTOR_DIMENSION_COUNT( TO_VECTOR('[34.6, 77.8]', 2, FLOAT64) );

VECTOR_DIMENSION_COUNT(TO_VECTOR('[34.6,77.8]',2,FLOAT64))
----------------------------------------------------------
2

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