In my previous post, I tried to use views and macros together as an equivalent to parameterized views. Unfortunately, my generic macro can’t handle bind variables, which are crucial because i…| An Oracle Programmer
Folks like me who research table macros would sometimes like them to be truly dynamic, such as when PIVOTing rows into columns.| An Oracle Programmer
No plagiarism here!| An Oracle Programmer
Like everything else in SQL macros, parameters are used differently from what we know or expect.| An Oracle Programmer
A polymorphic SQL table macro can produce rows with different “shapes”, but the “shape” is established at parse time, not execution time.| An Oracle Programmer
Testing SQL table macros in the Cloud(19c, 20c preview) and on LiveSQL (19.8): behaviors are different, and the differences change with time!| An Oracle Programmer
Developers like to reuse code. In SQL, views are reusable queries with lots of advantages, but one drawback: no parameters to limit the queries to only those rows we want. Sure, we can add a WHERE …| An Oracle Programmer
I just updated my COMPARE_ROWSETS function to handle an optional primary or unique key.| An Oracle Programmer
The GROUP BY method for comparing table data just turned 18. To celebrate, let’s make it a macro.| An Oracle Programmer
My previous JUST_PIVOT solution for dynamic pivoting does not work in Oracle DB 21c: sorry about that!| An Oracle Programmer
To show the power of the JUST_PIVOT macro, here are several examples.| An Oracle Programmer
You do the aggregation and the JUST_PIVOT table macro will pivot the result, dynamically!| An Oracle Programmer
Sometimes it would be easier to SELECT saying what columns we don’t want, not those we do.| An Oracle Programmer
My SQL Macro Utility package provides services for SQL macro development and execution.| An Oracle Programmer