ABS(-123) ABS(0) ABS(456) SIGN(-123) SIGN(0) SIGN(456) : ABS « Numeric Math Functions « Oracle PL / SQL






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

ABS(-123) ABS(0) ABS(456) SIGN(-123) SIGN(0) SIGN(456)

 

SQL>
SQL> select  abs(-123),  abs(0),  abs(456)
  2  ,      sign(-123), sign(0), sign(456)
  3  from   dual;

 ABS(-123)     ABS(0)   ABS(456) SIGN(-123)    SIGN(0)  SIGN(456)
---------- ---------- ---------- ---------- ---------- ----------
       123          0        456         -1          0          1

SQL>








Related examples in the same category

1.The ABS() function returns the absolute value of a numeric input argument.
2.ABS(x): Returns the absolute value of x
3.ABS: Returns the absolute value of a number or value
4.select abs(13.4) from dual;
5.select abs(-4.5) from dual;
6.select abs(-70 * 415) "Using an expression"
7.Use ABS in PL/SQL statement