Oracle PL/SQL Tutorial/Numerical Math Functions/Introduction

Common numerical manipulation functions

1. near value functions.
2. null value functions.
3. log and exponential functions.
4. ordinary trigonometry functions.
5. hyperbolic trignometrical functions.

14. 1. Introduction 14. 1. 1. Common numerical manipulation functions 14. 1. 2. <A href="/Tutorial/Oracle/0280__Numerical-Math-Functions/NumericFunctionsList.htm">Numeric Functions List</a>

Numeric Functions List

Numeric functions perform calculations.

Numeric functions accept an input number, which may come from a column in a table or from an expression that evaluates to a number.

A calculation is performed with this input and a number is returned.

An example of a numeric function is SQRT(), which returns the square root of the input number.

Function Description ABS(x) Returns the absolute value of x. ACOS(x) Returns the arccosine of x. ASIN(x) Returns the arcsine of x. ATAN(x) Returns the arctangent of x. ATAN2(x, y) Returns the arctangent of x and y. BITAND(x, y) Returns the result of performing a bitwise AND on x and y. COS(x) Returns the cosine of x, where x is an angle in radians. COSH(x) Returns the hyperbolic cosine of x. CEIL(x) Returns the smallest integer greater than or equal to x. EXP(x) Returns the result of the number e raised to the power x, where e is approximately 2.71828183. FLOOR(x) Returns the largest integer less than or equal to x. LOG(x, y) Returns the logarithm, base x, of y. LN(x) Returns the natural logarithm of x. LN(2.71828183) = 1 MOD(x, y) Returns the remainder when x is divided by y. POWER(x, y) Returns the result of x raised to the power y. ROUND(x [, y]) Returns the result of rounding x an optional y decimal places. If y is omitted, x is rounded to zero decimal places. If y is negative, x is rounded to the left of the decimal point. SIGN(x) Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero. SIN(x) Returns the sine of x. SINH(x) Returns the hyperbolic sine of x. SQRT(x) Returns the square root of x. TAN(x) Returns the tangent of x. TAN(0) = 0 TANH(x) Returns the hyperbolic tangent of x. TRUNC(x [, y]) Returns the result of truncating x an optional y decimal places. If y is omitted, x is truncated to zero decimal places. If y is negative, x is truncated to the left of the decimal point.