M1
NVL(M1,100)
--NVL(p1,p2) function has two parameters.If p1 is null then its take p2 AS values --EX:-NVL(M1,0) means "M1" columns as null value then its take "0" instead of null values. --In your query M1,M2 columns has null values so arithmetic operation is not possible so NVL function is used. SELECT EMP_ID ,(NVL(M1,0)+NVL(M2,0)) AS TOTAL FROM table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)