作用

空值转换函数
nvl(value,default_value) - Returns default value if value is null else returns value

demo

select
  nvl("abc", "123") as n1,
  nvl("", "123") as n2,
  nvl(null, "123") as n2

输出

abc

123