This post was inspired by the fact I couldn't find many good references for what I thought was 'previously discovered truth'. So...

Saddened but not surprised to see COALESCE lagging behind NVL. Weekend #SQL poll: when mapping binds/columns that could contain nulls to...

Once was a time when I read a few questions every morning at AskTom . It only took a few minutes but the amount of hints, tips, tricks and...

How many times do you think you've ever written something like this nvl('x',user) Small cost? What if you executed it all the...

In the experience I've had, I've found NVL such a ubiquitous expression. I started my Oracle career on 8.1.7, and it was the only ex...

There are some features in the database that are understandably difficult to first come across. Unless you have a specific need to fulfil, o...