Archives: 11/17/2016

Multiplying Using a Sum in Oracle

Here’s a example of how multiplying using logarithms: select exp(sum(ln(cd_deposito))) from anag_depositi where cd_deposito in (98,92, 95) ln(x*y) = ln(x) + ln(y) ==> exp(ln(x*y)) = exp(ln(x)) + exp(ln(y)) ==> using sum operator to implement multiplication

Go Top