NVL2 « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. NVL2
15.4.NVL2
15.4.1.NVL2(x, value1, value2) returns value1 if x is not null.
15.4.2.nvl2(comm,12*msal+comm,12*msal) as yearsal
15.4.3.Use nvl2 to deal with null salary
15.4.4.Use the NVL() against a non-initialized BOOLEAN variable: