Weekend #SQL poll: when mapping binds/columns that could contain nulls to non-nulls do you use:— SQL Daily (@sqldaily) July 1, 2016
Why? Because I think coalesce is a good idea and the modern equivalent of NVL.
I follow @SQLDaily for useful tips. Oracle SQL evangelist Chris Saxon runs the feed.