Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: user defined function like sum or avg
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