The following query:
SELECT NVL2('England', 'France', 'Spain');
returns the second argument, 'France', because the first argument is not NULL.
The following query:
SELECT NVL2('England', 'France', 'Spain');
returns the second argument, 'France', because the first argument is not NULL.