Oracle君でのCase式でIN句を使ってみたら

使えました♪

select
case when col_1 in ('hoge', 'hoke') then 1 else 0 end,
col_2
from
(
select 'hoge' as col_1, 'hoge' as col_2 from dual
union
select 'hoke' as col_1, 'hoke' as col_2 from dual
union
select 'hone' as col_1, 'hone' as col_2 from dual
) a

もちろん「not in」にしたら逆になります。

まぁ当たり前っていったらそれまでなんですけど、何気に感動したので(^_^;)