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
原文：https://www.cnblogs.com/chendian0/p/10445325.html