Term: CORR

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

• Oracle Numeric Functions: CORR

• Number Functions: CORR - Returns the coefficient of correlation of a set of number pairs.
• UPDATE: Correlated Update - You can write a subquery that SQL may have to re-evaluate as it examin...