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






  1. Oracle PL/SQL Tutorial
  2. Numerical Math Functions
  3. SIGN
SQL> select SIGN(0) from dual;

   SIGN(0)
----------
         0








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)