Sql Macros
-
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 similarity searches using binary vectors and float32 vectors. 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
-
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
-
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
Recent
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)