Numeric Functions in Oracle (Full List)

Below is a list of numeric functions in Oracle Database.

ABS()Returns the absolute value of its argument.
ACOS()Returns the arccosine (inverse cosine) of its argument.
ASIN()Returns the arcsine (inverse sine) of its argument.
ATAN()Returns the arctangent (inverse tangent) of its argument.
ATAN2()Returns the arctangent (inverse tangent) of its two arguments.
BITAND()Returns a bitwise AND of its two arguments.
CEIL()Returns the smallest integer that is greater than or equal to its argument.
COS()Returns the cosine of its argument.
COSH()Returns the hyperbolic cosine of its argument.
EXP()Returns the value of e (the base of natural logarithms) raised to the power of the argument.
FLOOR()Returns the largest integer equal to or less than its argument.
LN()Returns the natural logarithm of its argument, where the argument is greater than 0.
LOG()Returns the logarithm, base n2, of n1, where n2 is the first argument and n1 is the second.
MOD()Returns the modulo operation. In other words, it returns the remainder of its first argument divided by its second.
NANVL()Allows us to deal with NaN values by specifying another number to return in its place.
POWER()Returns its first argument raised to the power of its second argument.
REMAINDER()Returns the remainder of its first argument divided by its second.
ROUND()Returns a number rounded to a given number of decimal places.
SIGN()Returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive, and also depending on whether the argument is of type NUMBER or a floating-point number.
SIN()Returns the sine of its argument, where the argument is an angle expressed in radians.
SINH()Returns the hyperbolic sine of its argument.
SQRT()Returns the square root of its argument.
TAN()Returns the tangent of its argument, where the argument is an angle expressed in radians.
TANH()Returns the hyperbolic tangent of its argument.
TRUNC()Returns a given number, truncated to a given number of decimal places.
WIDTH_BUCKET()Allows you to construct equiwidth histograms, in which the histogram range is divided into intervals that have identical size.