In Oracle, the COS() function returns the cosine of its argument.

Continue reading →

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.

Continue reading →

In Oracle, the CEIL() function returns the smallest integer that is greater than or equal to its argument.

Continue reading →

In Oracle, the FLOOR() function returns the largest integer equal to or less than its argument.

Continue reading →

In Oracle, the LOG() function returns the logarithm, base n2, of n1, where n2 is the first argument and n1 is the second.

Continue reading →

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 reading →

In Oracle, the ATAN2() function returns the arctangent (inverse tangent) of its two arguments.

Continue reading →

In Oracle, the ATAN() function returns the arctangent (inverse tangent) of its argument.

In other words, it returns the value whose tangent is the argument.

Continue reading →

In Oracle, the BITAND() function returns a bitwise AND of its two arguments.

Continue reading →

In Oracle, the ASIN() function returns the arcsine (inverse sine) of its argument.

In other words, it returns the value whose sine is the argument.

Continue reading →