Oracle/PLSQL: Var_pop Function
In Oracle/PLSQL, the var_pop function returns the population variance of a set of numbers.
The syntax for the var_pop function is:
var_pop( expression )
expression is a numeric expression.
The var_pop function eliminates all null values before performing its calculations.
Applies To:
- Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
For Example:
select var_pop(data_length)
from all_tab_columns;