select (case when '123456'<>'' then 'not null' else 'is null' end) as fname from dual;
select (case when 3=0 then 3 else 1 end) as fname from dual;
select (5-8)/(case when 8=0 then 1 else 8 end) as rate
select (case when '123456'<>'' then 'not null' else 'is null' end) as fname from dual;
select (case when 3=0 then 3 else 1 end) as fname from dual;
select (5-8)/(case when 8=0 then 1 else 8 end) as rate
转载于:https://www.cnblogs.com/biyutong/archive/2011/12/15/2289525.html