ABS

See ABS

ACOS

Output value is in radians. See ACOS

ASIN

Output value is in radians. See ASIN

ATAN

Output value is in radians. See ATAN

ATAN2

Two-argument version of ATAN. This enables the function to use the sign of x and y to determine the quadrant of the result. See ATAN2

CBRT

Returns the cubic root of a given number.

CEILING

See CEILING

COS

Input argument is in radians. See COS

COT

Input argument is in radians. See COT

DEGREES

See DEGREES

EXP

See EXP

FLOOR

See FLOOR

LN()

Returns the natural log (base e) of a number. If you need the base 10 of a number, use the LOG function instead.

LOG

Returns the base 10 of a number. See LOG If you need the base 2 (natural) number instead, use the LN () function.

LOG10

Returns the log (base 10) of a number.

MOD

Modulo. Returns the remainder after dividing the first number by the second number. For example, 18 modulo 12 is 6 (18/12 = 1 with remainder 6, the result).

NUMERIC_LOG

Same as LOG.

Oracle ROWNUM

A number indicating the order in which Oracle selects the row from a table or set of joined rows. ROWNUM=1 for of the first row selected, ROWNUM=2 for the second row selected, and so on.

PI

See PI

POW

Variant form of POWER.

POWER

See POWER

RADIANS

See RADIANS

RAND

Same as RANDOM.

RANDOM

Returns a pseudo-random FLOAT value that is greater than 0 but less than 1.

ROUND

See ROUND (for date/time) and ROUND (for numbers)

SIGN

Returns the positive or negative sign of the input expression, or 0 if the input expression resolves to zero.

SIN

Input argument is in radians. See SIN

SINH

See SINH

SQRT

See SQRT

TAN

Input argument is in radians. See TAN

TANH

See TANH