The ABS() function returns the absolute value of a numeric input argument. : ABS « Numeric Math Functions « Oracle PL / SQL

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




The ABS() function returns the absolute value of a numeric input argument.

  
SQL>
ABS() Syntax:  ABS(<numeric expression>)
SQL>
SQL> SELECT
  2     ABS(-100) negative,
  3     ABS(100)  positive from dual;

  NEGATIVE   POSITIVE
---------- ----------
       100        100










Related examples in the same category

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