Use of COALESCE and NVL

NVL is a function which only takes two parameters and returns the first if it is not NULL, otherwise it returns the second. NVL always evaluates both arguments/expressions. COALESCEĀ is a function that will return the first non-NULL item in its parameter list. COALESCE doesn’t evaluate anything after it finds the first non-NULL argument. Note: Depending on… Continue reading Use of COALESCE and NVL