Numerical Math Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Numerical Math Functions
  4. 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
The following example displays the sign of -5, 5, and 0, respectively:

SQL>
SQL> SELECT SIGN(-5), SIGN(5), SIGN(0) FROM dual;
  SIGN(-5)    SIGN(5)    SIGN(0)
---------- ---------- ----------
        -1          1          0
SQL>