The following where clause expression would normally return false, therefore the query would deliver no rows. select * from dual where null...

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

It's nearly 8am, you're holding your favourite morning beverage, and you open yesterdays APEX tab, only to find this: This is t...

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

If there's one thing I've ever learned while developing in Oracle, there is always more than one way to solve a problem. The quest...

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...