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.