Oracle Numeric Functions

Numeric functions accept numeric input and return numeric values.

• ABS
• ACOS
• ASIN
• ATAN
• ATAN2
• BITAND
• CEIL
• COS
• COSH
• EXP
• FLOOR
• LN
• LOG
• MOD
• NANVL
• POWER
• REMAINDER
• ROUND (number)
• SIGN
• SIN
• SINH
• SQRT
• TAN
• TANH
• TRUNC (number)
• WIDTH_BUCKET

ABS Function

ABS Function returns the absolute value of a number.

Examples

SELECT ABS(-15) "Absolute" FROM DUAL;

  Absolute
----------
        15

abs(-23)  would return 23
abs(-23.6)  would return 23.6
abs(-23.65)  would return 23.65
abs(23.65)  would return 23.65
abs(23.65 * -1)  would return 23.65

ACOS Function

ACOS Function returns the arc cosine of a number. The argument number must be in the range of -1 to 1, and the function returns a value in the range of 0 to pi, expressed in radians.

Examples

SELECT ACOS(.3)"Arc_Cosine" FROM DUAL;

Arc_Cosine
----------
1.26610367

acos(0.2) would return 1.36943840600457
acos(0.35) would return 1.21322522314939
acos(-0.15) would return 1.72136459957158