Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables

Today I received a request from an application owner who wanted to know the size of all the CLOB and BLOB columns in all the non-system tables so that they have a good idea of the size involved for a migration. Tables with BLOB/CLOB columns The SQL to find the tables with the BLOB/CLOB columns … Continue reading Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All 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