Oracle – Simple/Reusable Statement Runner Using PL/SQL Table Type (Collection)

In an Oracle anonymous block based script, how many times do you run into situations where what needs to be done remains a constant but what that logic works with, keeps changing? Parameters are a great way to do it too but in the illustration below, we are going to use PL/SQL table type (collection). … Continue reading Oracle – Simple/Reusable Statement Runner Using PL/SQL Table Type (Collection)

Advertisements

Oracle – Scheduling a procedure to run later using dbms_job

Update: Although it is still relevant today, this was originally written years ago for Oracle 9i and below. dbms_scheduler is the recommended method to schedule, in the newer versions of Oracle. Occasionally, everyone has a need to kick off some PL/SQL procedure later in the day/night because some condition will not be met until that … Continue reading Oracle – Scheduling a procedure to run later using dbms_job