Practical Pl/Sql: Explorations In Oracle Pl/Sql programming.
-
Sparse Vectors
An exploration of support for sparse vectors in Oracle database 23ai. In this article I review the capabilities and limitations of working with sparse vectors in SQL and PL/SQL.
-
Binary Vectors: Semantic Searches
After using a variety of models to generate float32 vectors, we can convert these vectors to binary dimension formats using a macro. This allows us to explore and compare various approaches to vector similarity searches using binary vectors and float32 vectors.
-
Binary Vectors: Quantization
A step-by-step exploration into the details of creating a scalar sql macro function to quantize binary vectors from vectors in other dimension formats.
-
OML4PY 2.1 Quickstart
Quickstart guide to installing OML4PY and exporting augmented embedding models using VirtualBox appliance for 23.7.
-
Vector Math: Semantic Arithmetic
An exploration of some simple examples of vector arithmetic using vector embeddings generated within the Oracle database.
-
Vector Math: Basics
An exploration of the new vector arithmetic operations in Oracle 23ai Release 7. These operations currently support addition, subtraction and multiplication with vectors.
-
Sparse Vector Storage: Setting Compatible Parameter on OCI Autonomous Database
You can’t always get what you want…. Sometimes new features that come with a release update require the compatible initialization parameter to be set to a specific release or greater. VirtualBox 23ai Setting this parameter from a privileged account in a pluggable database won’t work: If you are running a 23AI Free database on virtual
-
Incremental Rounding: Numbers
A look at using pl/sql to create user defined functions and sql macros for incremental rounding.
-
WITH Function Macros
Use sql macros as functions in the WITH clause to easily prototype macros.
-
Table Data Comparison: Column Differences
Using sql table macros to make finding row and column differences simple.
Got any topic recommendations or feedback?
Practical Pl/Sql 