NVL2

NVL2: NULL VALUE LOGIC 2

Purpose NVL2 lets you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3. Data Types The argument expr1 can have any data type. The arguments expr2 and expr3 can have any data types except LONG. If the data types of expr2 and expr3 are different, then Oracle Database implicitly converts one […]

NVL2: NULL VALUE LOGIC 2 Read More »

NVL2()

Syntax. NVL2( string1, value_if_not_null, value_if_null )

The Oracle/PLSQL NVL2 function extends the functionality found in the NVL function NVL2 lets you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3. The argument expr1 can have any data type. The arguments expr2 and expr3 can have

NVL2() Read More »

Scroll to Top