Re: Create aggregate functions

From: Dave Fowler <d.fowler_at_smmj.com>
Date: Mon, 23 Apr 2001 23:21:59 GMT
Message-ID: <rO2F6.3665$5t3.281799@newsread1.prod.itd.earthlink.net>

Yes.
Write your own function in PLSQL in your own schema with the data tables being used.

create function your_max_function (arguement1 number,arguement2 varchar2) return number
is
.... local variables here
begin
... logic here
exception
when others then
dbms_output.put_line(substr(sqlerrm,1,100)); end;

Reference them in select your_max_function( argument1,argument2...) from your_table.

hth
Dave Fowler

"S P Arif Sahari Wibowo" <arifsaha_at_yahoo.com> wrote in message news:Pine.LNX.4.33.0104211732280.32570-100000_at_gede.parokinet.org...
> Hi!
>
> Is there any way to define my own aggregate functions in Oracle 8.1.6? So
> I can get my own version of MAX function, for instance. Preferably using
> PL/SQL.
>
> Thanks!
>
> --
> S P Arif Sahari Wibowo
> _____ _____ _____ _____
> /____ /____/ /____/ /____ arifsaha_at_yahoo.com
> _____/ / / / _____/ http://www.arifsaha.com/
>
Received on Mon Apr 23 2001 - 18:21:59 CDT