select decode(条件,值1,返回值1,值2,返回值2,…值n,返回值n,缺省值)
select decode(2-1,1,111,2,222,3,33,444) from dual
返回:1111
select decode(3-1,1,111,2,222,3,33,444) from dual
返回:2222
select decode(sign(3-1),1,111,222) from dual
sign(3-1) 返回 (正数:1 ), (负数: -1), (0)
返回:111