w3resource logo


Oracle Tutorial

Oracle Numeric Functions

Secondary Nav

Introduction

The Oracle numeric functions take a numeric input as an expression and return numeric values. The return type for most of the numeric functions is NUMBER.

Oracle Numeric Functions are :

Functions Description
ABS Calculates the absolute value of an expression.
ACOS Calculates the angle value (in radians) of a specified cosine.
ASIN Calculates the angle value (in radians) of a specified sine.
ATAN Calculates the angle value (in radians) of a specified tangent.
ATAN2 Returns a full-range (0 - 2 pi) numeric value indicating the arc tangent of a given ratio.
BITAND Computes an AND operation on the bits of two integers.
CEIL Returns the smallest whole number greater than or equal to a specified number.
COS Calculates the cosine of an angle expression.
COSH Calculates the hyperbolic cosine of an angle expression.
EXP Returns e raised to the nth power, where e equals 2.71828183....
FLOOR Returns the largest whole number equal to or less than a specified number.
LN Returns the natural logarithm of an expression.
LOG Computes the logarithm base 10 of an expression.
MOD Returns the modulus of a number.
NANVL Returns alternate number if the value is Not A Number (NAN).
POWER Returns m_value raised to the n_value power
REMAINDER Returns the remainder after one numeric expression is divided by another.
ROUND Returns the number rounded to the nearest multiple of a second number you specify or to the number of decimal places indicated by the second number.
SIGN Returns a value that indicates if a specified number is less than, equal to, or greater than 0 (zero).
SIN Calculates the sine of an angle expression. The result returned by SIN is a decimal value with the same dimensions as the specified expression.
SINH Calculates the hyperbolic sine of an angle expression.
SQRT Computes the square root of an expression.
TAN Calculates the tangent of an angle expression.
TANH Calculates the hyperbolic tangent of an angle expression.
TRUNC Truncates a number to a specified number of decimal places.
WIDTH BUCKET Returns the bucket number into which the value of an expression would fall after being evaluated.