decode(a,1,2,3) --a=1,输出2,否则输出3
select decode(a,1,2,2,4,9) from TABLENAME --相当于switch a=1,为2,等于2为4,其他为9
select decode(1+1,2,1,0) from dual --1+1=2输出1否则0,相当于if else
decode(a,1,2,3) --a=1,输出2,否则输出3
select decode(a,1,2,2,4,9) from TABLENAME --相当于switch a=1,为2,等于2为4,其他为9
select decode(1+1,2,1,0) from dual --1+1=2输出1否则0,相当于if else