Tag Archives: NVL2 function in Oracle

NVL2 function in Oracle

Last updated on October 30th, 2018 at 04:33 amNVL2 function is a nesting function .It examines the first impression, if the the first impression is not null ,then NVL2 function returns the second expression. if the first impression is null, then it return the third expression. expr1: it is the source values or expression which may contain null. You can provide column name,function on the … Continue reading NVL2 function in Oracle »