SIGN(5) (2) : SIGN « Numerical Math Functions « Oracle PL/SQL Tutorial





SQL> select SIGN(5) from dual;

   SIGN(5)
----------
         1










14.18.SIGN
14.18.1.SIGN(x) gets the sign of x. SIGN() returns -1 if x is negative, 1 if x is positive, or 0 if x is zero.
14.18.2.Use SIGN function to deal with column data
14.18.3.SIGN(-5)
14.18.4.SIGN(5) (2)
14.18.5.SIGN(0)