Category: JSON
-
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.
-
Table Data Comparison: Column Differences
Using sql table macros to make finding row and column differences simple.
-
Dynamic Unpivot Using JSON_DATAGUIDE
In this post I will explore a way to generate and run unpivot queries dynamically in PL/SQL. We will build a utility package to dynamically create unpivot queries using json and leveraging json_dataguide…
-
Table Data Comparison: Row Differences
A common task that database developers encounter is comparing data between two different sources to see rows with differences. This can be a table that is loaded with new data that needs to…
Recent
- Sparse Vectors
- Binary Vectors: Semantic Searches
- Binary Vectors: Quantization
- OML4PY 2.1 Quickstart
- Vector Math: Semantic Arithmetic
Categories
Archives
- 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 