Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: user defined function like sum or avg

Re: user defined function like sum or avg

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Fri, 07 Sep 2001 13:51:12 GMT
Message-ID: <kh4m7.1322$he4.1281840@news1.news.adelphia.net>


Yes, PL/SQL can be used to write user functions that work in selects. I have never done it, but I read about it just this week (this was in 8i). Look in the online docs in OTN (free sign up) at www.oracle.com.

"Markus Stuhlpfarrer" <mstuhlpfarrer_at_hollomey.com> wrote in message news:3B985F04.F78700AB_at_hollomey.com...
> hello,
>
> my question is, if it is possible to write a user defined function in
> pl/sql
> that can be used like sum, count or avg?
> so that it works even in a group by (but without a select in the
> function)
> i only want to get all the values and concat them or something like that
>
>
>
Received on Fri Sep 07 2001 - 08:51:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US