SIGN(5) : SIGN « Numeric Math Functions « Oracle PL / SQL






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

SIGN(5)



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(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero
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