Aspects


vs


Coalesce

COALESCE is a SQL function that returns the first non-NULL expression among its arguments

Nvl

`nvl` is a SQL function present in its vendor-specific implementation by Oracle