Practical Pl/Sql

Category: Pl/Sql

  • 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.

    read more

  • 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…

    read more

  • 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.

    read more

  • OML4PY 2.1 Quickstart

    Quickstart guide to installing OML4PY and exporting augmented embedding models using VirtualBox appliance for 23.7.

    read more

  • Vector Math: Semantic Arithmetic

    An exploration of some simple examples of vector arithmetic using vector embeddings generated within the Oracle database.

    read more

  • 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.

    read more

  • Incremental Rounding: Numbers

    A look at using pl/sql to create user defined functions and sql macros for incremental rounding.

    read more

  • WITH Function Macros

    Use sql macros as functions in the WITH clause to easily prototype macros.

    read more

  • Table Data Comparison: Column Differences

    Using sql table macros to make finding row and column differences simple.

    read more

  • 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…

    read more

Recent

Categories

Archives