VECTOR

VECTOR is synonymous with TO_VECTOR.

Syntax

Description of the illustration vector_vecse.gif

Purpose

See TO_VECTOR for semantics and examples.

Note:

Applications using Oracle Client 26ai libraries or Thin mode drivers can insert vector data directly as a string or a CLOB. For example:

INSERT INTO vecTab VALUES ('[1.1, 2.9, 3.14]');

Examples

SELECT VECTOR('[34.6, 77.8]');

VECTOR('[34.6,77.8]')
--------------------------------------------------------- [3.45999985E+001,7.78000031E+001]



SELECT VECTOR('[34.6, 77.8]', 2, FLOAT32);

VECTOR('[34.6,77.8]',2,FLOAT32)
--------------------------------------------------------- [3.45999985E+001,7.78000031E+001]



SELECT VECTOR('[34.6, 77.8, -89.34]', 3, FLOAT32);

VECTOR('[34.6,77.8,-89.34]',3,FLOAT32)
----------------------------------------------------------- [3.45999985E+001,7.78000031E+001,-8.93399963E+001]