Oracle Numeric Functions
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