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.

Read more

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.

Read more