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 …

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 …

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 …