語法:
sign(value1 - value2)
說明:
sign()函數根據某個值是0, 正數還是負數, 分別返回0, 1, -1
範例:
value1 = 10 , value2 = 20
select decode(sign(value1 - value2), -1, 變量1, 變量2) from dual
則sign(value1 - value2)返回-1, decode解碼結果為“變量1”
語法:
sign(value1 - value2)
說明:
sign()函數根據某個值是0, 正數還是負數, 分別返回0, 1, -1
範例:
value1 = 10 , value2 = 20
select decode(sign(value1 - value2), -1, 變量1, 變量2) from dual
則sign(value1 - value2)返回-1, decode解碼結果為“變量1”