# 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

**Weekly Trends**- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook