Category: SQL
-
Temporal SQL Assertions III: Effective Periods
In the previous post of this series (Temporal SQL Assertions II: Ignore Legacy Data) we took a typical enterprise approach to applying business rules only to current data in motion and considering older data…
-
Temporal SQL Assertions II: Ignore Legacy Data
In the previous post (Temporal SQL Assertions I: Unconditional and Unvalidated) we explored a naive solution that used SQL assertions to validate customer discounts for a customer loyalty program. The basic idea was sound,…
-
Temporal SQL Assertions I: Unconditional and Unvalidated
In this series of posts we will explore using assertions to enforce business rules in a changing data landscape. This first article explores the limitations of a simplistic approach to a problem that…
-
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…
-
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.
-
Vector Math: Semantic Arithmetic
An exploration of some simple examples of vector arithmetic using vector embeddings generated within the Oracle database.
-
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…
-
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.
Recent
- Temporal SQL Assertions III: Effective Periods
- Temporal SQL Assertions II: Ignore Legacy Data
- Temporal SQL Assertions I: Unconditional and Unvalidated
- Sparse Vectors
- Binary Vectors: Semantic Searches
Categories
Archives
- March 2026
- November 2025
- August 2025
- May 2025
- April 2025
- March 2025
- December 2024
- November 2024
- August 2024
- July 2024
- February 2024
- September 2023
- June 2023
- May 2023
Practical Pl/Sql 