-SIGN(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero : SIGN « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. SIGN

-SIGN(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero


SQL> --SIGN(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero.
SQL>
SQL> select SIGN(-5) from dual;

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

SQL>








Related examples in the same category

1.SIGN: Returns 1 if the argument is positive, 0 if the argument is negative
2.SIGN(0)
3.SIGN(5)
4.Use sign function in user-defined function
5.select sign( 100 - ( 50 * 2 ) ) "Using expressions"
6.select sign( 123 * -1 + 122) "Using expressions"
7.Use SIGN in PL/SQL statement