Practical PL/SQL

Explorations In Oracle PL/SQL programming and SQL.

  • 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

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

  • VirtualBox23ai QuickStart for OML4PY

    Are you excited about the new AI Vector Search in Oracle 23ai! Have you been able to do a vector search in the new database without calling external APIs to do vector embeddings? Unless you are skilled in Python and Linux, this… 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 to create json_table and unpivot sql expressions. read more

  • 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 be compared with existing rows to see what rows… read more

  • Cursor Basics: Cursor Iteration Controls

    In the previous post we discussed the use of bulk collect and limit to optimize cursor iteration. This gave us a way to see the undocumented bulk prefetch optimization that has been applied behind the scenes to the cursor for loop. Unless… read more

Recent
Categories
Archives
Topics

AI (3) AI Vector Search (7) artificial-intelligence (3) Best Practices (2) Binary Vectors (1) Binary Vector Searches (1) Ceil (1) Comparing Table Data (1) Cursor For Loop (2) Cursors (3) Cursor Variables (2) data-science (1) Database Compatible Parameter (1) Dynamic SQL (2) IDE (1) Inline CTE Functions (2) LLM (3) machine-learning (1) OCI Autonomous Database (1) OML4PY 2.1 (1) ONNX (2) Oracle 19c (3) Oracle 21c (4) Oracle 23ai (12) Oracle AI Database 26.1 (4) Oracle Database 23.7 (2) Polymorhic Table Functions (1) pragma UDF (1) Ref Cursors (2) Reranking Similarity Searches (1) Round (1) Sparse Vector Storage Format (1) Sql Assertions (4) Sql Macros (6) Sql Transpiler (1) technology (3) Trunc (1) vector (1) Vector Arithmetic (2) Vector Data Type (2) Vector Math (2) Vector Similarity (1)