Sign gives the sign of a value.
Syntax: sign (value)
Ex:
SQL> select sign(5), sign(-5), sign(0), sign(null) from dual;
SIGN(5) SIGN(-5)
SIGN(0) SIGN(NULL)
---------- ---------- ---------- --------------
1 -1
0
