Oracle SQL query tutorial for beginners Numerical Functions Part I

Oracle SQL query tutorial for beginners : Numerical Functions Part-I

Function Description
ABS Returns the absolute value of n. If n is 0 or a positive integer, returns n. Otherwise, n is multiplied by -1.

CEIL Returns the smallest integer value not less than n.

EXP Exponentiation, where the base is e. Returns the value of e (the base of natural logarithms) raised to the power n.

FLOOR Returns the largest integer value not greater than n.

LN Natural logarithm. Computes the logarithm of its single argument, the base of which is e.

LOG Logarithm. log n, m takes two arguments, where n is the base, and m is the value you are taking the logarithm of.

MOD Modulo. Returns the remainder of n divided by m.

*This oracle sql tutorial may help you to understand oracle in live class learning from home