- with
- abc(col1)
- as
- (
- select '2' from dual
- union all
- select '4' from dual
- union all
- select '3' from dual
- )
- select col1,ln(col1),exp(sum(ln(col1))over()) from abc;
- 2 0.693147180559945 24
- 4 1.38629436111989 24
- 3 1.09861228866811 24
来源: http://www.bubuko.com/infodetail-2969823.html