decode
只有Oracle才有,且在處理大數據量時不如case when
with
tmp_table
as(
select '1' col1 from dual
union all
select '2' col1 from dual
union all
select '3' col1 from dual
)
select col1,
case when col1 = '1' then 'a'
when col1 = '2' then 'b'
else 'c' end result1,
decode(col1,'1','a','2','b','c') result2
from tmp_table