Nvl
From Oracle FAQ
nvl is an Oracle SQL function that will return a non-NULL value if a NULL value is passed to it.
NVL(a,b) == if 'a' is null then return 'b'.
[edit]
Examples
SELECT nvl(salary, 'Sorry, no pay!') FROM employees;
[edit]
Also see
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
