with
abc(col1)
as
(
select '' from dual
union all
select '' from dual
union all
select '' 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
2023-01-06 14:41:01
with
abc(col1)
as
(
select '' from dual
union all
select '' from dual
union all
select '' 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