Dynamic SQL
-
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
-
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 alternatives that the particular situation might merit. In this… 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)