Product aggregate function

Few months ago I needed an product aggregate function. It’s strange that Oracle does not have such functionality. I think it’s pretty trivial. Here is it is: CREATE OR REPLACE TYPE product_impl AS OBJECT ( product NUMBER, STATIC FUNCTION ODCIAggregateInitialize(ctx IN OUT product_impl) RETURN NUMBER,...
Continue reading »

Bitcount aggregate function

Finally, a blog post after ages :). Recently I received a new feedback on my two years old article on bitwise or aggregate function, where a visitor is looking for a bitcount aggregate function. This was a nice exercise for me. After a little of...
Continue reading »