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
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
My SQL Macro Utility package provides services for SQL macro development and execution.| An Oracle Programmer