Oracle Tip – Generate “N” rows of dates or numbers serially

Sometimes, you would have a situation where you need to generate a table with N number of rows that you can use as the basis to join and restrict other tables. For example, to get the 100 dates starting from a certain date as rows, a typical technique is to select ROWNUM from all_objects to … Continue reading Oracle Tip – Generate “N” rows of dates or numbers serially

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

Oracle: Using Oracle Trace from code without “tkprof” – The basics

Update: Although it is still relevant today, this was originally written in Aug 2012. A lot of times, in your PL/SQL application, you might run into an error but do not know what statement caused the error. The program might lack any form of outputting (to UTL folder, log tables or otherwise). The simplest way … Continue reading Oracle: Using Oracle Trace from code without “tkprof” – The basics