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]
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]
Oracle Licensing (or: WTF Partitioning?!)
I came across this post about Oracle partitioning licensing a couple weeks ago (yes I'm catching up with all the blogging). In it, Mathias basically doesn't think that partitioning should be separately licensed at all, and included in ALL versions of Oracle.For those of you who haven't had the pleasure:To... [Read More]
Perils and Pitfalls in Oracle Partitioning: Bind Variables?
Recently one of my developers found some articles by Arup Nanda while researching a query performance problem. The articles were title "Perils and Pitfalls in Partitioning," parts 1 and 2.In particular he was curious about this statement in part 2:While using partitioning, should you use bind variables? This is an... [Read More]
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]