How to add your own aggregate function

Everyone knows the standard aggregate functions (sum, avg, and so on).
But they always don’t meet your needs. For instance, what about a product aggregate function?
This tip will show you how to add your own aggregate function. This is quite simple and can be done with a function and a type.
Note that’s available only in 9i+.

I’ll take the example (which is meaningless) of a square product; that is the square root of the product of all elements by group of rows.

Pages: 1 · 2 · 3 · 4