空值转换函数
nvl(value,default_value) - Returns default value if value is null else returns value
select
nvl("abc", "123") as n1,
nvl("", "123") as n2,
nvl(null, "123") as n2
输出
abc 123
空值转换函数
nvl(value,default_value) - Returns default value if value is null else returns value
select
nvl("abc", "123") as n1,
nvl("", "123") as n2,
nvl(null, "123") as n2
输出
abc 123
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
