Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replacing NULL values to zero to perform arithmetic operation on Column

deekayMar 4 2011 — edited Mar 4 2011
Hi ,

Please enlighten me the way to achieve this.

I want to make addition operation on Salary column in EMP table.
Some values are null in salary column.I want to replace null value with zero and make the addition.


Like: I want to add 15 where for emp 1 and his sal is null.
it should be 0+15=15


Thanks,
Deekay.
This post has been answered by BluShadow on Mar 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2011
Added on Mar 4 2011
4 comments
10,600 views