Oracle Numeric Functions

Numeric functions accept numeric input and return a numeric value. This page organizes commonly used Oracle numeric functions to help you with mathematical operations.

  1. ABS

    Oracle ABS() is a built-in function that returns the absolute value of the given parameter.

  2. ACOS

    Oracle ACOS() is a built-in function that returns the arccosine of a given number.

  3. ASIN

    Oracle ASIN() is a built-in function that returns the arcsine of a given number.

  4. ATAN

    Oracle ATAN() is a built-in function that returns the arctangent of a given number.

  5. ATAN2

    Oracle ATAN2() is a built-in function that returns the arc tangent of two given arguments.

  6. BITAND

    Oracle BITAND() is a built-in function that returns the result of a bitwise AND operation of two parameters.

  7. CEIL

    Oracle CEIL() is a built-in function that returns the smallest integer value greater than or equal to a specified number.

  8. COS

    Oracle COS() is a built-in function that returns the cosine of a given radian.

  9. COSH

    Oracle COSH() is a built-in function that returns the hyperbolic cosine of a specified value.

  10. EXP

    Oracle EXP() is a built-in function that returns the natural constant e raised to the power of the given parameter.

  11. FLOOR

    Oracle FLOOR() is a built-in function that returns the largest integer value less than or equal to the specified number.

  12. LN

    Oracle LN() is a built-in function that returns the natural logarithm of the number given by the parameter.

  13. LOG

    Oracle LOG() is a built-in function that returns the logarithm of a given value, taking a given value as the base.

  14. MOD

    Oracle MOD() is a built-in function that returns the remainder after dividing two specified numbers.

  15. POWER

    Oracle POWER(x, y) is a built-in function that returns the y power of x.

  16. REMAINDER

    Oracle REMAINDER() is a built-in function that returns the remainder after dividing two specified numbers.

  17. ROUND(number)

    Oracle ROUND(number) is a built-in function that rounds a given number to a given number of decimal places.

  18. SIGN

    Oracle SIGN() is a built-in function that returns -1, 0, or 1 to indicate the given number is negative, zero or positive.

  19. SIN

    Oracle SIN() is a built-in function that returns the sine of a given value in radians.

  20. SINH

    Oracle SINH() is a built-in function that returns the hyperbolic sine of a specified value.

  21. SQRT

    Oracle SQRT() is a built-in function that returns the square root of a given number.

  22. TAN

    Oracle TAN() is a built-in function that returns the tangent of the specified radian.

  23. TANH

    Oracle TANH() is a built-in function that returns the hyperbolic tangent of a specified value.

  24. TRUNC(number)

    Oracle TRUNC(number) is a built-in function that truncates the specified number to the specified precision (0 by default) and returns the result.

  25. WIDTH_BUCKET

    Oracle WIDTH_BUCKET() is a built-in function that returns the number of a bucket which the specified value falls in.