NVL2 « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. NVL2
1.NVL2(x, value1, value2):Returns value1 if x is not null; if x is null, value2 is returned
2.NVL2(x, value1, value2): for string(char) value
3.nvl2 with null value
4.Use nvl2 to deal with null salary