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

Advertisement

Oracle Tip – EXECUTE IMMEDIATE With Bind Variable Input In Dynamic SQL

Caution:┬áIf there is no need to use a dynamic SQL, you should always use regular non-dynamic SQL. This is a bad usage of dynamic SQL and I am only doing so to illustrate the use of bind variables. The task: Again, I just wanted to provide a basic example that shows the usage of EXECUTE … Continue reading Oracle Tip – EXECUTE IMMEDIATE With Bind Variable Input In Dynamic SQL

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