Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple question
As far as i know not. You would have to use something like a cursor in
PL/SQL to concatinate the columns.
Marc
"Bruno D." <bd@_avirer_arte-tv.com> wrote in message
news:3bb8785a$0$14589$4d4eb98e_at_read.news.fr.uu.net...
> Is it possible to create a group function like SUM() or COUNT() ?
>
> I would create something like that:
>
> TABLE tab(txt varchar2(5)) with the following lines:
> ab
> bcd
> efg
>
>
> The goal: select myfunc(txt) from tab; would give:
>
> 'abcdefg'
>
> Anybody ??
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Bruno Durrenberger
> mailto:bd_at_arte-tv.com
>
Received on Mon Oct 01 2001 - 09:36:29 CDT