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