Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

Oracle - System Functions

Overview

Function Description
NVL() Replaces NULL value with specified value

NVL

Oracle - NVL
Syntax NVL(expr1, expr2)
Description 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.
Return Type The arguments expr1 and expr2 can have any datatype. If their datatypes are different, then:
1)If expr1 is character data, then Oracle Database converts expr2 to the data type of expr1 before comparing them and returns VARCHAR2 in the character set of expr1.
2)If expr1 is numeric, then Oracle determines which argument has the highest numeric precedence, implicitly converts the other argument to that datatype, and returns that datatype.

Equivalents in Other Databases

Database Equivalent
SQL Server ISNULL and COALESCE functions


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

sqlways/oracle/system-functions.txt · Last modified: May 07, 2018, 03:15:30 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement