# Numeric Functions

FunctionDescription
abs(x)absolute value of x
BITAND(x,y)a bitwise AND on x and y.
CEILReturns the ceiling value (next highest integer above a number).
EXPReturns e raised to a value.
FLOORReturns the floor value (next lowest integer below number).
LN(n),LOG(m,n)Natural logarithm, and logarithm base m
ModReturns The Remainder Of N/M Where Both N And M Are Integers.
POWERReturns value raised to some exponential power.
REMAINDER(n1, n2)Identifies the multiple of n2 that is nearest to n1, and returns the difference between those two values.
ROUNDReturns the number rounded to nearest value, adjusts precision.
SignReturns 1 If The Argument Is Positive; -1 If The Argument Is Negative; And 0 If The Argument Is Negative.
Sqrt(x)Square Root Of x
TRUNCReturns the truncated value (removes decimal part of a number, precision adjustable).
SIN(n),
COS(n),
TAN(n)
Sine, cosine, and tangent of n (n expressed in radians)
ASIN(n),
ACOS(n),
ATAN(n)
Arcsine, arccosine, and arctangent of n
SINH(n),
COSH(n),
TANH(n)
Hyperbolic sine, hyperbolic cosine, and hyperbolic tangent of n
ATAN2(x,y)Returns the arctangent of x and y.
Home »
Oracle »
Numeric_Functions