SIGN returns a NUMBER that specifies the sign of the 1st argument.

The possible return values are:

-1 if the number is 0
-1 if the number is aBINARY_FLOAT or BINARY_DOUBLE and is = 0 or is Nan

Example:

SELECT SIGN(-100) AS sign_value FROM DUAL;

SIGN_VALUE
——————–
-1

Sign – Oracle SQL Function
Tagged on: