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 |
|---|---|
| CORR | Returns the coefficient of correlation of a set of number pairs. |
| COVAR_POP | Returns the population covariance of a set of number pairs. |
| COVAR_SAMP | Returns the sample covariance of a set of number pairs. |
| CUME_DIST | Returns the cumulative distribution of a value in a group of values. |
| DENSE_RANK | Returns the rank of a row in a group of rows. |
| FIRST_VALUE | Returns the first value in an ordered set of values from an analytic window. |
| LAG | Returns values from a previous row in the table. |
| LAST_VALUE | Returns the last value in an ordered set of values from an analytic window. |
| LEAD | Returns values from the next row in the table. |
| LISTAGG | Concatenates values of the measure_column for each GROUP based on the order_by_clause. |
| NTH_VALUE | Returns the nth value in an ordered set of values from an analytic window. |
| RANK | Returns the rank of a value in a group of values. |
| STDDEV | Returns the standard deviation of a set of numbers. |
| VAR_POP | Returns the population variance of a set of numbers. |
| VAR_SAMP | Returns the sample variance of a set of numbers. |
| VARIANCE | Returns the variance of a set of numbers. |