Oracle Vector - SQL Demo

It demonstrates how you can perform vector operations on Oracle AI Vector Search.

🚀 Getting Started

You can quickly get an image of Oracle Database 23ai Free (using Podman):

podman run --name oracle32aifree -p 1521:1521 -e ORACLE_PWD=password container-registry.oracle.com/database/free:latest

I am using the all_MiniLM_L12_v2.onnx embedding model for generating vectors. You can download it here.

The load_embedding_model_adb.sql is used for loading external files (embedding model and pdfs). It works if you are using Autonomous Database.

Run load_embedding_model_podman.sql if you are running Oracle 23ai from a Podman container.

Create sample_data table and load the rows using load_embedding_model_adb.sql file

Then, just run the demo.sql file (on sqlplus, sqlcl, SQL Developer Web or VS Code) one by one to understand how each command works.

demo.sql

Name		Name	Last commit message	Last commit date
Latest commit History 10 Commits
README.MD		README.MD
create_sample_data.sql		create_sample_data.sql
demo copy.sql		demo copy.sql
demo.sql		demo.sql
load_embedding_model_adb.sql		load_embedding_model_adb.sql
load_embedding_model_podman.sql		load_embedding_model_podman.sql
load_pdf_adb.sql		load_pdf_adb.sql
load_pdf_podman.sql		load_pdf_podman.sql