Skip to content

Tag Archives: sql

Process the whole world, or just one item

05-Nov-09

One of my favorite PL/SQL techniques used in batch job development is to add an extra parameter, default it to NULL, so that I can test a single account at a time. example So the real trick is the NVL in the where clause – If I supply a value for in_employer_id that’s the only [...]

Filed in Uncategorized | Also tagged , | Comments (5) »

Manager: How big is my table? Me: What do you mean?

03-Nov-09

Recently, a data warehouse manager sent me a list of 49 tables; he wants the approximate size of each. For an end-user, this is no easy task. Sure, GUI interfaces such as Toad or OEM will give this information, but not all managers (or developers for that matter) know how to get this information. Furthermore, [...]

Filed in Uncategorized | Also tagged , , , , | Comments (0) »