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