In Oracle, the MOD() function returns the modulo operation. In other words, it returns the remainder of its first argument divided by its second.
Tag: numeric functions
EXP() Function in Oracle
In Oracle, the EXP() function returns the value of e (the base of natural logarithms) raised to the power of the argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
Continue readingCOSH() Function in Oracle
In Oracle, the COSH() function returns the hyperbolic cosine of its argument.
COS() Function in Oracle
In Oracle, the COS() function returns the cosine of its argument.
ROUND(number) Function in Oracle
In Oracle, the ROUND(number) function returns a number rounded to a given number of decimal places.
By default, it rounds the number to zero decimal places, but you can provide an optional argument that specifies the number of decimal places to use.
Oracle also has a ROUND(date) syntax, which is used on dates. This article is solely about the ROUND(number) syntax, which is used on numbers.
CEIL() Function in Oracle
In Oracle, the CEIL() function returns the smallest integer that is greater than or equal to its argument.
FLOOR() Function in Oracle
In Oracle, the FLOOR() function returns the largest integer equal to or less than its argument.
LOG() Function in Oracle
In Oracle, the LOG() function returns the logarithm, base n2, of n1, where n2 is the first argument and n1 is the second.
LN() Function in Oracle
In Oracle, the LN() function returns the natural logarithm of its argument, where the argument is greater than 0.
In other words, it returns the base-e logarithm of its argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
Continue readingATAN2() Function in Oracle
In Oracle, the ATAN2() function returns the arctangent (inverse tangent) of its two arguments.