Calculating the Data in Oracle
Posted on 2011-09-27
I had to calculate varience in oracle. I know there is a function in oracle named varience
I am doing VARIENCE as (MyExpectedData - MyActualReturns)
1. How Does Varience Work...
2. Alo I want to Return data as Percentage for one of the column which is a combination of two columns as:
(Column1/Column2)*100 as myNewData
But this does has errors, if there is a division by zero. It throws an error and second how do i bring its result in percentage sign with it