SQL oracle 添加一个值

Question

假设我想选择有奖学金的学生并在该值上加 150，为没有奖学金的学生加 100。我试过了:

select name,scholarship+150 as "New scholarship"from students which bursa is null union select name,scholarship+100 as "New scholarship"from students which bursa is null;

但只对那些有奖学金的人增加了新的值(value)。你能帮帮我吗

Answer 1

如果 scholarship 可能为 NULL，将其替换为 nvl(scholarship,0) 或 coalesce(scholarship,0)

select scholarship + case when bursa is not null then 150 else 100 end ...

或

select scholarship + decode (bursa,null,100,150) ...

或

select scholarship + nvl2 (bursa,150,100) ...