select case when DUMMY = 'X' then 1 else NULL end from dual
case when DUMMY='X'then1else NULL end
blanks are losts
reopened because problem on case in GROUP BY
is not fixed
other problem to fix:
case when t.l in ('A') then 'One' when t.l in ('B') then 'Two' end col
case when t.l in ('A')('B') as col
this is fixed for case in select
with 2015.04 release
Case WHEN VALUE between 0 and0.99 THEN ...
Case WHEN length( env ) 0 and0.99 THEN 1 end AS between
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.