Thursday, September 3, 2009

NVL2

NVL2 extend the functionality of NVL.

Following is the syntax.

NVL2(Expression, value1, value2)

If expression is not NULL then return value1

If expression is NULL then return value2.

Thanks,
Soham Khot