Oracle/PLSQL: Variance Function
In Oracle/PLSQL, the variance function returns the variance of a set of numbers.
The syntax for the variance function is:
variance( expression )
expression is a numeric expression.
Applies To:
- Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
For Example:
select variance(char_length)
from all_tab_columns;