Oracle null-related Functions

NULL-related functions help to deal with NULL values. This page organizes the commonly used NULL-related functions in Oracle.

  1. COALESCE

    Oracle COALESCE() is a built-in function that returns the first non-null value in a list of arguments.

  2. LNNVL

    Oracle LNNVL() is a built-in function that provides a concise way to evaluate a condition when one or both operands are NULL. It returns FALSE if the condition is TRUE, and TRUE if the condition is FALSE or UNKNOWN.

  3. NANVL

    Oracle NANVL() is a built-in function that allows you to provide a default value for parameters that have a value of NaN. It is only applicable to BINARY_FLOAT and BINARY_DOUBLE data types.

  4. NULLIF

    Oracle NULLIF() is a built-in function that compares two arguments and returns NULL if they are equal, otherwise it returns the first argument.

  5. NVL

    Oracle NVL() is a built-in function that allows you to replace NULL values with a specified value.

  6. NVL2

    Oracle NVL2() is a built-in function that allows you to determine which value to return based on whether an expression is null.