Practical Pl/Sql

Category: SQL

  • Table Data Comparison: Column Differences

    Using sql table macros to make finding row and column differences simple.

    read more

  • VirtualBox23ai QuickStart for OML4PY

    Are you excited about the new AI Vector Search in Oracle 23ai! Have you been able to do a vector search in the new database without calling external APIs to do vector embeddings?…

    read more

  • 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

  • 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…

    read more

  • Cursor Basics: Cursor Iteration Controls

    In the previous post we discussed the use of bulk collect and limit to optimize cursor iteration. This gave us a way to see the undocumented bulk prefetch optimization that has been applied…

    read more

  • Writing Excellent Code

    Once you have started to absorb the fact that there are many ways to accomplish a given programming task, you should find yourself asking questions like the following. What is the best way…

    read more

Recent

Categories

Archives