Re: Statistics...

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 21 Aug 1998 13:49:01 GMT
Message-ID: <01bdcd0a$499c77c0$a12c6394@J00679271.ddc.eds.com>

Oracle provides a stand deviation function with the rdbms, stddev(value) along with most of the standard numeric related functions like sin, power, floor, etc...
PL/SQL allows you to code either functions or procedures that accept parameters so you can code what Oracle does not provide

See the first few chapters of the SQL manual for information on supported SQL functions and the PL/SQL manual for its functions (usually the same name and purpose)

Luis Díez Porres <0768495198#luis_at_cuende-asociados.es> wrote in article > .....
> I need to use some statistical functions, such as standard deviation.
> Is there any standard package I could use?
>
> I know I could use PL/SQL to create some proc/func, but I need it to
> accept variable parameters, and that's not possible (or am I wrong?).
>
Received on Fri Aug 21 1998 - 08:49:01 CDT