Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The LOG10 function computes the logarithm base 10
of an expression.
DECIMAL
LOG10(expression)
The value of expression must be greater than zero. When the value is equal to or less than 0
(zero), LOG10 returns an NA
value.
OLADM1758Example 8-15 Calculating a Base 10 Logarithm
This example uses the LOG10 function to calculate the base 10 logarithm of 1,000. The statement
SHOW LOG10(1000)
produces the following result.
3.00