Plz do abide to our Terms & Condition:

    • Do not paste URL Links directly in any content instead post them as Hyperlink inside a text.
       
    • To post a Link directly use instead Bookmark.
       
    • If we find anyone posting beyond the warning we will immediately terminate your account without any warning. 

what is abs function in oracle?

Answers (1)

    • rimal
      By rimal

      In Oracle/PLSQL, the abs function returns the absolute value of a number. which will always be zero or a positive number.

      Syntax

      The syntax for the abs function is:

      abs( number )

      number is the number to convert to an absolute value.

      SELECT ABS(-100) FROM DUAL;

      Applies To

      • Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

      For Example

      ABS(20.537) will return '20'
      ABS(-11.2) will return '11'
      ABS(15) will return '15'
      ABS(0005) will return '5'