ABS is one of the vital Numeric/Math functions of Oracle. It is used to get the absolute value of a number. The ABS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
ABS ( number )
Parameters:
number:
It is used to specify the number to get the absolute value of.
Example 1:
ABS (-11) |
Output:
11
Explanation:
The absolute value function always returns the positive value of a number and so is the result.
Example 2:
ABS (-11.11) |
Output:
11.11
Explanation:
The absolute value function always returns the positive value of a number and so is the result.
Example 3:
ABS (11.11 * -2) |
Output:
22.22
Explanation:
The absolute value function always returns the positive value of a number and so is the result.