In Oracle/PLSQL, the covar_pop function returns the population covariance of a set of number pairs.
Syntax
The syntax for the covar_pop function is:
covar_pop( expression1, expression2 )
expression1 is a numeric expression.
expression2 is a numeric expression.
Note
The covar_pop function eliminates all pairs where expression1 or expression2 has a null value.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
select owner, covar_pop(avg_row_len, avg_space)
from all_tables
group by owner;