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