Re: user defined aggregate function

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 14 Jun 1999 11:12:09 GMT
Message-ID: <3772e35a.12898487@newshost.us.oracle.com>

A copy of this was sent to "Simon Wright" <simon_at_syntrium.com> (if that email address didn't require changing) On Mon, 14 Jun 1999 09:17:15 +0100, you wrote:

>Is it possible to write an aggregate function for Oracle v8.x
>
>I can't see anyway in PL/SQL but maybe there's a way in Oracle8i?
>

You cannot write an aggregate function like "min, max, count, sum, etc"....

you can write functions that provide aggregate results though.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 14 1999 - 06:12:09 CDT