The Oracle CORR function calculates the Pearson's correlation coefficient, which is the coefficient of correlation of a set of number pairs. It can be used as an aggregate or analytic function.
Pearson's correlation reflects the degree of linear relationship between two variables. It ranges from +1 to -1. A correlation of +1 means that there is a perfect positive linear relationship between variables.
Related Code Snippets: