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. |