ORACLE ABS FUNCTION

ORACLE ABS FUNCTION

                        ABS FUNCTION RETURNS ABSOLUTE VALUE OF THE EXPRESSION

SYNTAX: abs(expr) 

QUERY:  get absolute value of -10

SQL> SELECT ABS(-10.22) FROM DUAL;

ABS(-10.22)
-----------
      10.22

QUERY:  get absolute value of '-10+20-30'

SQL> select abs(-10+20-30) from dual;

ABS(-10+20-30)
--------------
            20

QUERY: get absolute value of dates.

SQL> select abs(months_between(to_date('1973-12-12','yyyy-dd-mm'),sysdate)) from dual;

MONTHS_BETWEEN(TO_DATE('1973-12-12','YYYY-DD-MM'),SYSDATE)
----------------------------------------------------------
                                                 472.7595

   

QUERY: Display absolute values of variable.

SQL>declare n number;

SQL>exec :n:=-10;

SQL>select :n,abs(:n) from dual;

   :n    abs(:n)

------ -------------------

-10    10