Re: aggregate function

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 20 Dec 2000 22:22:48 -0800
Message-ID: <3A41A1B8.4B361202@exesolutions.com>

slezakp_at_billmax.com wrote:

> Can one write an aggregate function in Oracle 8.1.6?
>
> Example: normal sum
>
> select sum(tools) from powertools;
>
> I want to be able to do:
>
> select mysum(tools) from powertools.
>
> Note that mysum will not know what table or column ahead of time.
>
> Thanks,
> Paul
>
> Sent via Deja.com
> http://www.deja.com/

Look at Oracle's Dynamic SQL in older versions and Native Dynamic SQL in 8.1.6. It allows you to construct any SQL statement on the fly in a function, procedure, or package.

Dan Morgan Received on Thu Dec 21 2000 - 00:22:48 CST