how to query by vector? demo only show to insert vector.

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle

https://oracle.github.io/python-oracledb

Other

342 stars 69 forks source link

how to query by vector? demo only show to insert vector. #403

Closed ovjust closed 1 month ago

ovjust commented 1 month ago

as to the title.

cjbj commented 1 month ago

https://github.com/oracle/python-oracledb/tree/main/samples
https://python-oracledb.readthedocs.io/en/latest/user_guide/vector_data_type.html
https://download.oracle.com/ocomdocs/global/python-oracledb_Vector_Technical_Brief_Oracle_Database_23ai.pdf

ovjust commented 1 month ago

i know it, now. -- 成功 SELECT name,VECTOR_DISTANCE(v,(SELECT v FROM genvec WHERE name='C'||'5'),EUCLIDEAN) FROM genvec where VECTOR_DISTANCE(v,(SELECT v FROM genvec WHERE name='C'||'5'),EUCLIDEAN)<1 ORDER BY VECTOR_DISTANCE(v,(SELECT v FROM genvec WHERE name='C'||'5'),EUCLIDEAN)

cjbj commented 1 month ago

For other readers, a good reference is:

https://docs.oracle.com/en/database/oracle/oracle-database/23/vecse/overview-ai-vector-search.html