Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

NVL

Syntax

NVL(expr1, expr2)

If expr1 is NULL, the function returns expr2. If expr1 is not NULL, the function returns expr1. The NVL function is usually used to replace NULL values with specified value.

Example

This example selects title and price for all books. If the price for a given title is NULL, the price shown is 0.00.

SELECT title, NVL(price, 0.00) AS price 
FROM titles; 

Equivalents in other databases

TABLE 83. Equivalents in other databases

IBM DB2	COALESCE function
Microsoft SQL Server	ISNULL and COALESCE functions