Printable View
I am planning to write a PL/SQL procedure to perform some math calculations. The math formulas has 'log' function with base 2. [ e.g. log2(25) ]. Would you please provide me your feedback on how to code this in SQL.
The complete formula is something like this.
log2(x1)-log2(x2)-log2(x3)
x1,x2,x3 are the column names in my oracle table and I need to calculate the value for each row in the table using above formula.
Thanks,
Ramesh
log(a,b) returns the log, base a of b
log(2,x1)-log(2,x2)-log(2,x3)
However, what is the relationship among x1, x2, and x3? I'm trying to think of a mathematical situation where you would be subtracting successive logs beyond the case of log x - log y.
log(2/3) = log 2 - log 3
If you have x1/x2, and then divided by x3, or x1 divided by x2/x3, then your equation would make sense. You could do log(2,x1/x2) - log(2,x3), or log(2,x1) - log(2,x2/x3).
Thanks your feedback stevencallan.
Actually, I have x3/x4, etc.. in place of variables x1,x2,x3 that I stated for simplicity. Your feedback provides answer to my question.
Thanks again.
Ramesh