Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle CORR Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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.

Related Links:

Oracle Numeric Functions: CORR

Related Code Snippets:

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

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: