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

VECTOR_NORM

VECTOR_NORM returns the Euclidean norm of a vector as a BINARY_DOUBLE. This value is also called the magnitude or size and represents the Euclidean distance between the vector and the origin. For a vector v = (v1, v2, ..., vn), the Euclidean norm is given by ||v|| = SQRT(v12 + v22 + ... + vn2).

Syntax


Description of vector_norm.eps follows
Description of the illustration vector_norm.eps

Parameters

expr must evaluate to a vector.

If expr is NULL, NULL is returned.

Example

SELECT VECTOR_NORM( TO_VECTOR('[4, 3]', 2, FLOAT32) );

VECTOR_NORM(TO_VECTOR('[4,3]',2,FLOAT32))
____________________________________________
5.0

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