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.

For example:

select variance (char_length)
from all_tab_columns;