The difference between NVLL and coalesce in Oracle

NVL (commission_pct,0)
If the first argument is null, the second argument is returned
If the first argument is non-null, the first argument is returned

COALESCE (EXPR1,EXPR2,EXPR3 ... EXPRn)
A non-null value is returned when the first non-null value is encountered from left to right.
Multi-layered judgment

The 1th difference: from the above can be known, NVL only suitable for two parameters, coalesce suitable for a number of parameters.

The 2nd difference: all parameter types in coalesce must be consistent and NVL can be inconsistent.

The difference between NVLL and coalesce in Oracle