Oracle Numeric Functions

Last update on November 13 2023 11:00:01 (UTC/GMT +8 hours)

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.

Previous: Set Operators
Next: ABS