摘要:Oracle的Decode函數
語法:
decode(control_value,value1,result1[,value2,result2…][,default_result])
說明:
select decode( x , 1 , 'x is 1', 2 , 'x is 2', 'others') from dual
當x等於1時, 則返回'x is 1'
當x等於2時, 則返回'x is 2'
否則, 返回'others'
範例:
decode(yearage,0,' ',yearage,lpad(yearage,2,'0')||'歲')
select decode(sign(變量1-變量2),-1,變量1,變量2) from dual
