how i can get multiplication of all value os single column

hi
by sum function we can get the sum of can field by his query
select sum(xyx) from table_name;
but if i want the multilication of all the value how i can get.

Hi

I couldn't follow your question. Can you be a little clearer.

Of course you can multiply fields in a table to produce a summary

select sum(x*y*z*x) from table_name

Is this what you want?

Cheers
Nandu
:)

If you want to multiply all the values in one column for all rows in a query try using natural logs (though you will possibly loose precision).

select exp(sum(ln(column))) from ...


I suspect that there might be functions to do this in later versions of Oracle 8i to support easier data warehousing but I'm not sure.