Oracle functions are built into Oracle and are available for use in various appropriate Oracle statements. You can also create your own function using PL/SQL.
| Function | Description |
|---|---|
| ABS | Returns the absolute value of n. |
| ACOS | Returns the arc cosine of n. |
| ASIN | Returns the arc sine of a number. |
| ATAN | Returns the arc tangent of a number. |
| ATAN2 | Returns the arc tangent of n and m. |
| AVG | Returns the average value of an expression. |
| BITAND | Returns an integer representing an AND operation on the bits of expr1 and expr2. |
| CEIL | Returns the smallest integer value that is greater than or equal to a number. |
| COS | Returns the cosine of a number. |
| COSH | Returns the hyperbolic cosine of a number. |
| COUNT | Returns the count of an expression. |
| EXP | Returns e raised to the nth power |
| FLOOR | Returns the largest integer value that is equal to or less than a number. |
| GREATEST | Returns the greatest value in a list of expressions. |
| LEAST | Returns the smallest value in a list of expressions. |
| LN | Returns the natural logarithm of a number. |
| LOG | Returns the logarithm of n base m. |
| MAX | Returns the maximum value of an expression. |
| MEDIAN | Returns the median of an expression. |
| MIN | Returns the minimum value of an expression. |
| MOD | Returns the remainder of m divided by n. |
| POWER | Returns m raised to the nth power. |
| REGEXP_COUNT | Counts the number of times that a pattern occurs in a string. |
| REMAINDER | Returns the remainder of m divided by n. |
| ROUND (numbers) | Returns a number rounded to a certain number of decimal places. |
| ROWNUM | Returns a number that represents the order that a row is selected by Oracle from a table or joined tables. |
| SIGN | Returns a value indicating the sign of a number. |
| SIN | Returns the sine of n. |
| SINH | Returns the hyperbolic sine of n. |
| SQRT | Returns the square root of n. |
| SUM | Returns the summed value of an expression. | TAN | Returns the tangent of n. |
| TANH | Returns the hyperbolic tangent of n. |
| TRUNC (numbers) | Returns a number truncated to a certain |