Practical Pl/Sql

Tag: 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…

    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…

    read more

Recent

Categories

Archives