Is there a select function to add cols that are often null?

[somethingsimil]

I have a complex query where I select and add a number of columns, which are sometimes null...

SELECT a+b+c (query is much much larger)

...sometimes "a" is null and it makes the whole result null even when b and c have value. Is there a function to add and ignore nulls? If I wrap each terms in nvl the query gets too long for command line use.

[Admin]

The only function to handle NULL values is NVL(). Or, you can update NULLs before the summation as follows:

Code: Select all

UPDATE table1 SET col_name1=NVL(col_name1,0)
UPDATE table1 SET col_name2=NVL(col_name2,0)
...