Supported Clients and Languages

For more information about Oracle AI Vector Search support using some of Oracle’s available clients and languages, see the included reference material.

Clients and Languages	Reference Material
PL/SQL	Oracle AI Database PL/SQL Language Reference
MLE JavaScript	Oracle AI Database JavaScript Developer’s Guide
JDBC	Oracle AI Database JDBC Developer’s Guide
Node.js	node-oracledb documentation
Python	python-oracledb documentation
Oracle Call Interface	Oracle Call Interface Developer’s Guide
ODP.NET	Oracle Data Provider for .NET Developer’s Guide
SQL*Plus	SQL*Plus User’s Guide and Reference

Oracle AI Database 26ai supports binding with native VECTOR types for all Oracle clients. Applications that use earlier Oracle Client 26ai libraries can connect to Oracle AI Database 26ai in the following ways:

• Using the TO_VECTOR() SQL function to insert vector data, as shown in the following example:

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

• Using the FROM_VECTOR() SQL function to fetch vector data, as shown in the following example:

  SELECT FROM_VECTOR(dataVec) FROM vecTab;