The computer has come to shape our world and the universe. It is so important that we cannot do without this fantastic invention. You would have heard about networking before. Networking is all about connection, the concept of networking can be applied to every facet of human life. It refers to a computer as well.

What does the following query do in oracle?

Fayyazuddin

SELECT SAL + NVL(COMM,0) FROM EMP;

Anil

This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to the salary.
wherever the commission is null, it is replaced by 0 & added to the salary.