Oracle ABS() Function
The Oracle (PL/SQL) ABS() function returns the absolute value of a given number.
Syntax
ABS(number)
Parameters
number |
Required. Specify the number to convert to an absolute value. |
Return Value
Returns the absolute value of a given number.
Example 1:
The example below shows the usage of ABS() function.
ABS(15) Result: 15 ABS(-15) Result: 15 ABS(25.23) Result: 25.23 ABS(-25.23) Result: 25.23 ABS(0) Result: 0 ABS(10 * -2) Result: 20
Example 2:
Consider a database table called Sample with the following records:
| Data | x |
|---|---|
| Data 1 | -10 |
| Data 2 | -5 |
| Data 3 | 0 |
| Data 4 | 5 |
| Data 5 | 10 |
The statement given below can be used to calculate the absolute value of column x.
SELECT Sample.*, ABS(x) AS ABS_Value FROM Sample;
This will produce the result as shown below:
| Data | x | ABS_Value |
|---|---|---|
| Data 1 | -10 | 10 |
| Data 2 | -5 | 5 |
| Data 3 | 0 | 0 |
| Data 4 | 5 | 5 |
| Data 5 | 10 | 10 |
❮ Oracle Functions
