Sure, you should certainly read my blog - and encourage everyone you know to do the same.

But there are lots of other fantastic Oracle technologists out there, and several write blogs on Toad World.

So today I would like to start the New Year by drawing your attention to the excellent writing of Dan Clamage. I've known Dan for years, since 1997 in fact (just searched my email history). He's reviewed some of my books, worked with (and provided excellent feedback on) a number of the tools I've built over the years, such as PL/Generator (which eventually morphed into the Quest CodeGen Utility).

Dan's a very sharp guy; I've benefited from his feedback and contributions many times over.

Dan started writing his Toad World blog on SQL and PL/SQL back in October 2012 and he's already assembled a collection of very interesting information. Much of it is motivated directly by the challenges he's faced in his work, and that's usually the way to come up with the best examples.

Here are links to just a few of his posts:

Dan goes way beyond an explanation of DBMS_UTILITY.FORMAT_ERROR_BACKTRACE to providing a utility, implemented in Oracle object types, that parses and displays the contents of the backtrace in a very useful way.

A fascinating exploration into creative ways to use collections to collate and sort data, in this case to "collate each unique email address and list out every application and job they were listed in. This was intended to aid in validating the proper form and accuracy (people often leave for greener pastures) of all internal email addresses, a monumental task that wound up taking weeks to analyze and correct."

You might not run into the need for updateable inline views often, but when you do, this post will be an invaluable resource!

0 comment(s) so far...