DISQUS

Robert Vollman · 4 years ago

You can also use DECODE, which (as an exception to the normal rule) will say that NULL = NULL

DECODE(COMM, NULL, 'SAL', 'SAL & COMM')

http://thinkoracle.blogspot.com/2005/06/decode....

But, keep in mind that NVL and NVL2 seem to have a performance hit over the more verbose manual NULL check.

http://thinkoracle.blogspot.com/2005/06/nulls-i...

orig article:
http://www.oracledba.co.uk/tips/plsql\_nvl\_cos...
discussion:
http://www.phpbbserver.com/phpbb/viewtopic.php?...

Cheers,
Robert
Eddie Awad · 4 years ago

Robert,
Thanks for the extra tips and links. I see you are a fan of Tom Kyte. I am too. I have learnt a lot from him, and still learning...

Cheers!
matelot · 2 years ago

heheh no loves for PL/SQL I guess

http://groups.google.com/group/comp.databases.oracle.server/msg/165d24ffccb982e7?dmode=source&hl=en