select sign( 123 * -1 + 122) "Using expressions" : SIGN « Numeric Math Functions « Oracle PL / SQL






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

select sign( 123 * -1 + 122) "Using expressions"

 
SQL>
SQL> select sign( 123 * -1 + 122) "Using expressions"
  2  from dual
  3  /
Using expressions
-----------------
               -1

1 row selected.

SQL>

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(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero
4.SIGN(5)
5.Use sign function in user-defined function
6.select sign( 100 - ( 50 * 2 ) ) "Using expressions"
7.Use SIGN in PL/SQL statement