VECTOR
VECTOR
is synonymous with
TO_VECTOR
.
Purpose
See TO_VECTOR for semantics and examples.
Note:
Applications using Oracle Client 23ai 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]
Parent topic: Vector Constructors