I'm Kind of a Big Deal Around Here

Yesterday Justin Kestelyn over at the OTN blog announced a re-org of the blogs.oracle.com homepage. I was pleasantly surprised to see my own name listed among the likes of Werner Puschitz, Jonathan Lewis, Howard Rogers and my new locker buddy Laurent Schneider. Jeremy Schneider is conspicuously absent, hopefully that gets... [Read More]
Tags: blogs oracle

What Is NULL?

Today in #oracle, Burk0 asked:<Burk0> mmm... got another problem... I'm using a "insert or update" trigger for my previous task. When I'm inserting a new row, I'd like the varchar field "oldvalue" to report "NA". I put an IF inside the trigger, checking if :old.id=null but that doesn't seem to... [Read More]
Tags: null oracle

Joining on substrings

Jonathan Lewis shared an example of joining two tables where the joining field on table is comprised of two fields on the other table. The original poster thought he'd need to re-design his table, but Jonathan proved otherwise with the grace and efficiency of a true Englishman.Definitely good to know!... [Read More]