Kangas had recently sold his share of a gambling business in Las Vegas, and he ran the Liberalism Resurgent page on the World Wide Web. The page published extensive criticism of conservatives, and some of its writings asserted that Scaife was the financier of a right-wing conspiracy to topple President Clinton.
The NVL function. You can use the NVL function to convert an expression that evaluates to NULL to a value that you specify. The NVL function accepts two arguments: the first argument takes the name of the expression to be evaluated; the second argument specifies the value that the function returns when the first argument evaluates to . If the first argument does not evaluate to NULL, the function returns the value of the first argument.
This is because NULL has been replaced by 100 via the NVL function, hence the sum of the 3 rows is 300 + 100 + 150 = 550. Next: SQL COALESCE Function