August 2002
Intermediate to advanced
528 pages
10h 12m
English
Oracle has added a variety of statistical functions to its database. Statistics such as correlation, covariance, and linear regression can be computed. The functions operate on unordered result sets, and they can be used with the windowing function. Table 9.2 describes the available functions
The use of the various functions is depicted in Listing 9.22. The functions are used to analyze the employee Wages values.
| Function Name | Description |
|---|---|
| VAR_POP | Computes the population variance of a number set after discarding all null values |
| VAR_SAMP | Computes the sample variance of a number set after discarding the null values (This function is similar to the VARIANCE function. The difference occurs when ... |