Sign function returns negative or positive based on the value of the number. It is a numeric function

Syntax :-

SIGN(n) returns -1 or 1 or 0

Example :-

SQL> select sign(-2) from dual;

SIGN(-2)
———-
-1

SQL> select sign(2) from dual;

SIGN(2)
———-
1

SQL> select sign(-2.5) from dual;

SIGN(-2.5)
———-
-1

SQL> select sign(0) from dual;

SIGN(0)
———-
0