Oracle Built In Functions:SIGN Function
In Oracle the SIGN function returns value indicating sign of a number
Syntax
SIGN(num)
In Oracle the SIGN function returns value indicating sign of a number
If num<0, the function returns -1.
If num=0, the function returns 0.
If num>0, the function returns 1.
Example
SELECT SIGN(-20) “Sign” FROM DUAL;
Sign
———-
-1