1. Oracle AI Vector Search User's Guide
  2. Use SQL Functions for Vector Operations
  3. Vector Distance Functions and Operators
  4. L1_DISTANCE

L1_DISTANCE

L1_DISTANCE is a shorthand version of the VECTOR_DISTANCE function that calculates the Manhattan distance between two vectors. It takes two vectors as input and returns the distance between them as a BINARY_DOUBLE.

Syntax


Description of l1_distance.eps follows
Description of the illustration l1_distance.eps

Parameters

  • expr1 and expr2 must evaluate to vectors and have the same format and number of dimensions.

  • L1_DISTANCE returns NULL, if either expr1 or expr2 is NULL.

Parent topic: Vector Distance Functions and Operators