i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
The NVL function
12-29-2010, 11:12 AM
Post: #1
The NVL function
The NVL() function is available in Oracle, and not in MySQL or SQL Server. This function is used to replace NULL value with another value. It is similar to the IFNULL Function in MySQL and the ISNULL Function in SQL Server.

For example, if we have the following table,

Table Sales_Data
store_name Sales
Store A 300
Store B NULL
Store C 150

The following SQL,
SELECT SUM(NVL(Sales,100)) FROM Sales_Data;

returns 550. This is because NULL has been replaced by 100 via the ISNULL function, hence the sum of the 3 rows is 300 + 100 + 150 = 550.



Oracle Certified Trainer
[Image: signature.php?uid=40]
Quote




User(s) browsing this thread: 1 Guest(s)