Re: How to write user-defined aggregate function

brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0211142305.391fb953_at_posting.google.com>...
> How to make a loop to get the values from sal? Where can I find a complete example?
>
> danielroy10_at_hotmail.com (Daniel Roy) wrote in message news:<1b061893.0211140710.194a2121_at_posting.google.com>...
> > create function my_function (sal in number)
> > return number is
> > "VARIABLE DECLARATION"
> > BEGIN
> > ....
> > return return_value;
> > end my_function;
> >
> >
> > > How to write an user-defined aggregate function? e.g. select
> > > my_function(sal) from emp;

Look up Oracle9i Data Cartridge Developer's Guide

Here is a link to the chapter
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96595/dci11agg.htm#1004572

• rajXesh