Archives

If you can't always perform automated regression testing, you can build a simple test harness and, as much as possible, make sure your procedures are broken up into units that can be easily tested. See Steven's example.

The execution of non-query DML can cause all sorts of SQL errors. Steven lays out guidelines in DML Handling code.

What should be in your exception handling section? Things pertaining to exception handling. What shouldn't? Application code. Learn more.

A developer takes out "insurance" when they write code to "make sure" or "just in case". This can be unnecessary & unproductive. See examples.

PL/SQL packages are great! But there is one package feature you shouldn’t use: Initialization. Your first inclination should be to avoid it. Steven Feuerstein explains why.

Steven discusses when it makes sense to choose a string-indexed associative array (one of the three types of PL/SQL collections)

Lazy can be a good developer characteristic or a terrible one depending on how and when applied. Steven and Marlyn look at examples of each.