SELECT SAL + NVL(COMM,0) FROM EMP;This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.

chengiri

 Profile Answers by chengiri Questions by chengiri

• Sep 3rd, 2009

Insted of NVL use SELECT SAL + isnull(COMM,0) FROM EMP which will convert null values to 0 of the field COMM

padma.rkp

 Profile Answers by padma.rkp Questions by padma.rkp

• Apr 28th, 2007

GIVES ADDED VALUE OF SAL & COMM FOR EACH EMPLOYEE

Answer Question  Select Best Answer