Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables

The goal of this post is to compare two text files that may have millions of lines and compare them to quickly find out which lines differ using Oracle EXTERNAL tables. As an Oracle professional, “external tables” are something you may already be familiar with or maybe you have heard about them but not used … Continue reading Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables

Oracle – Capture PL/SQL Output From DBMS_OUTPUT.PUT_LINE To Table Or File

Debugging PL/SQL Code: Stepping through code is a basic necessity for programmers to test and verify logic flow in code. Very few PL/SQL programmers use this capability. Most, if not all, rely on the capabilities of the Oracle supplied package DBMS_OUPUT. Specifically, the PUT_LINE procedure within DBMS_OUTPUT is used as a crutch for debugging needs. … Continue reading Oracle – Capture PL/SQL Output From DBMS_OUTPUT.PUT_LINE To Table Or File