3.5.3 Mathematical Functions and Operators

Table of Contents Previous Next


3 The SQL Language : 3.5 Functions and Operators : 3.5.3 Mathematical Functions and Operators

Mathematical operators are provided for many Advanced Server types. For types without common mathematical conventions for all possible permutations (e.g., date/time types) the actual behavior is described in subsequent sections.
LOG(b NUMBER, x NUMBER)
MOD(y, x)
NVL(x, y)
If x is null, then NVL returns y
POWER(a DOUBLE PRECISION, b DOUBLE PRECISION)
a raised to the power of b
POWER(a NUMBER, b NUMBER)
a raised to the power of b
ROUND(v NUMBER, s INTEGER)
Round to s decimal places
TRUNC(v NUMBER, s INTEGER)
WIDTH_BUCKET(op NUMBER, b1 NUMBER, b2 NUMBER, count INTEGER)
Return the bucket to which op would be assigned in an equidepth histogram with count buckets, in the range b1 to b2
ATAN2(x, y)

3 The SQL Language : 3.5 Functions and Operators : 3.5.3 Mathematical Functions and Operators

Table of Contents Previous Next