SQL Sign

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