How to add a number to null in Oracle?

select ename, sal, comm, sal+COALESCE(comm,0) as total_compensation from emp;

Click here for the screenshot.

--Moid

How to Build, Configure, Install 10g ASM database Server with migration steps on Linux? --Moid

Click here for the document.

--Moid

How to Install Oracle 11g R1 Software and configure database on Windows Vista?

Click here for the step-by-step (with screenshots) instructions on how to install Oracle 11g R1 database on Windows Vista.

--Moid

How to Install Oracle 10g database on XP?

Click here for the step-by-step (with screenshots) instructions on how to Install Oracle 10g Software and configure database on Microsoft XP.

--Moid