Category: Tutorials
-
OML4PY 2.1 Quickstart
Quickstart guide to installing OML4PY and exporting augmented embedding models using VirtualBox appliance for 23.7.
-
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?…
-
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…
-
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…
-
Cursor Basics: Bulk Binds
In the previous post we discussed the most basic approaches to iterating through a resultset using cursors. Since those approaches traverse the cursor one row at a time they are often referred to…
-
Cursor Basics: A Fetching Difference
There are some techniques that are really basic to what we do everyday as PL/SQL developers. There is a tendency to automatically do these basic things in the same way without considering the…
-
Getting Started For Free
Because the intended audience for this blog is anyone that works with or wants to work with Oracle PL/SQL, from the advanced expert to the beginner, I want to take a moment before…
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 