The schemes use the following functions:
AVG(expr)
: The average or mean of expr
; if x
is an attribute, AVG(x)
is the sum of the values of x
divided by the number of values.EXP(x)
: The constant e
raised to the xth power, where e
is approximately equal to 2.71828183. LN(x)
: The natural logarithm of x
, that is, the power to which e
must be raised to equal x
; x
must be > 0.LOG(10,x)
: The logarithm to the base 10 of x
, that is, the power to which 10 must be raised to equal x
(LOG(10,100)=2
); x
must be > 0.MAX(expr)
: The maximum value of expr
; if x
is an attribute, MAX(x)
is the maximum of the values of x
.MIN(expr)
: The minimum value of expr
; if x
is an attribute, MIN(x)
is the minimum of the values of x
.SQRT(x)
: The square root of x
, that is, the number whose square is x
(SQRT(x)*SQRT(x)=x
); x
must be >= 0.STDDEV(expr)
: The standard deviation of expr
. Standard deviation is the square root of variance.VARIANCE(expr)
: The variance of expr
. If expr
has one row, the variance is 0; otherwise, the variance is VAR_SAMP(expr)
, the sample variance of a set of numbers after discarding the nulls in the set.For more information about these functions, see the Oracle Database SQL Reference.
Copyright © 2006, 2008, Oracle. All rights reserved.