NVAL NVL Null no value in Oracle SQL

Argh, I seem to always forget this. Very annoying.

select nvl(
    (select emplid from psoprdefn where oprid = 'xxx')
, 'a') from dual

0 comments: