3.3.3 Mathematical Functions and Operators

Table of Contents Previous Next


3 Enhanced SQL Features : 3.3 Extended Functions and Operators : 3.3.3 Mathematical Functions and Operators

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 Enhanced SQL Features : 3.3 Extended Functions and Operators : 3.3.3 Mathematical Functions and Operators

Table of Contents Previous Next