两个办法..
1,case when 字段=xx then xx else xx end
2,decode
例如
select pid,(case name is null then '0' else '雨夜' end) from rain
select pid,decode(name,null,'0','雨夜') from rain
两个办法..
1,case when 字段=xx then xx else xx end
2,decode
例如
select pid,(case name is null then '0' else '雨夜' end) from rain
select pid,decode(name,null,'0','雨夜') from rain