SIGN « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. SIGN
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.select sign( 123 * -1 + 122) "Using expressions"
8.Use SIGN in PL/SQL statement