select nvl(bonus,0)+wage from teachers where teacher_id=7
select nvl2(bonus,bonus+wage,wage) from teachers where teacher_id=7
select coalesce(bonus+wage,wage) from teachers where teacher_id=7
Null+任何值都为空,不显示内容
select nvl(bonus,0)+wage from teachers where teacher_id=7
select nvl2(bonus,bonus+wage,wage) from teachers where teacher_id=7
select coalesce(bonus+wage,wage) from teachers where teacher_id=7
Null+任何值都为空,不显示内容