Oracle Numeric Functions
20 functions
ABSABS(n)Returns the absolute value.
CEILCEIL(n)Returns the ceiling.
FLOORFLOOR(n)Returns the floor.
ROUNDROUND(n [, d])Rounds to d decimal places.
TRUNCTRUNC(n [, d])Truncates to d decimal places.
MODMOD(m, n)Returns the remainder of m divided by n.
POWERPOWER(m, n)Returns m raised to the power of n.
SQRTSQRT(n)Returns the square root.
EXPEXP(n)Returns e raised to the power of n.
LNLN(n)Returns the natural logarithm.
LOGLOG(base, n)Returns the logarithm of the specified base.
SIGNSIGN(n)Returns 1, 0, or -1 for positive, zero, or negative.
REMAINDERREMAINDER(m, n)Returns the IEEE remainder of m/n.
BITANDBITAND(expr1, expr2)Returns the bitwise AND of two integers.
GREATESTGREATEST(v, ...)Returns the largest value from a list.
LEASTLEAST(v, ...)Returns the smallest value from a list.
NANVLNANVL(n, replacement)Returns a replacement value if the input is NaN.
SINSIN(n)Returns the sine value.
COSCOS(n)Returns the cosine value.
TANTAN(n)Returns the tangent value.