Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
NVL2 FunctionReturns the second argument when the first argument is not NULL. If the first argument is NULL, the third argument is returned.

NVL2 Function

Returns the second argument when the first argument is not NULL. If the first argument is NULL, the third argument is returned.

NVL2 Function

The NVL2 function is a synonym for the following code:

CASE WHEN expression IS NOT NULL
     THEN result-expression
     ELSE else-expression