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
- Group Composition Assertions I: Literal Rules
- Temporal SQL Assertions III: Effective Periods
- Temporal SQL Assertions II: Ignore Legacy Data
- Temporal SQL Assertions I: Unconditional and Unvalidated
- Sparse Vectors
Categories
- Announcements (2)
- JSON (4)
- Pl/Sql (15)
- Resources (4)
- SQL (17)
- SQL Macros (1)
- Tutorials (7)
- Vectors (8)
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) Floor (1) 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) Scalar Macros (1) Sparse Vector Storage Format (1) Sql Assertions (4) Sql Macros (6) Sql Transpiler (1) technology (3) Trunc (1) Type 2 Slowly Changing Dimensions (1) vector (1) Vector Arithmetic (2) Vector Data Type (2) Vector Math (2) Vector Similarity (1)
Archives