NVL Archives - Oracle SQL Tips, Tricks and Hacks

Adding optional conditions to your queries

Posted on August 18, 2015 by Carlos

The NVL function is very useful in a lot of different situations and is probably one of the most widely used among Oracle developers. One of the ways we can use it is to write queries that have ‘optional’ conditions.… Continue Reading →

Oracle NVL, NVL2 and COALESCE functions

Posted on August 13, 2015 by Carlos

I have seen quite a few questions on internet forums and knowledge exchange sites about Oracle NVL, NVL2 and COALESCE functions for handling nulls, so I decided to write an article about them today. Those functions are actually similar, but… Continue Reading →