Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> writing own analytic functions?

writing own analytic functions?

From: Thomas Blankschein <thomas_at_blankschein.de>
Date: Tue, 5 Apr 2005 21:20:56 +0200
Message-ID: <4252e521$0$27199$9b4e6d93@newsread4.arcor-online.net>


Hello,

in 9i I can write my own aggretate functions. I tried this successfully with a string aggreate and a product aggregate function. However, now I need a special analytic function which multiplies in the partition the values of a column. SUM() OVER... summarizes all values, I need something like MULTIPLY() OVER...
I checked the documentation but I didn't find anything about this. Can I write a custom analytic function? If not, how can I realize something similar with existing functions?

Thanks,
Thomas Received on Tue Apr 05 2005 - 14:20:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US