Coalesce
From Oracle FAQ
(Redirected from COALESCE)
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
|
|
Coalesce is an SQL function that returns the first expression that is NOT NULL.
SELECT COALESCE(NULL, '2', '5') FROM dual;
SELECT 'Dear '||COALESCE(preferred_name, first_name, 'Sir or Madam') FROM emp2;
| 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 | # |
