abs Function in Oracle

In Oracle, the ABS function is used to return the absolute value of a number. The absolute value of a number is its value without regard to its sign. 

Here's the syntax for the ABS function:

ABS(n)

Where n is the number for which you want to find the absolute value.

Here's an example:

SELECT ABS(-10) AS absolute_value FROM dual;

This query will return the absolute value of -10, which is 10.

You can also use the ABS function in combination with other columns or expressions in your SQL queries. For example:

SELECT column1, ABS(column2) AS absolute_value

FROM your_table;

This query will return the values of column1 and the absolute values of column2 for each row in your_table.