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: Simple question

Re: Simple question

From: Marc <langkamp_at_mailcity.com>
Date: Mon, 1 Oct 2001 16:36:29 +0200
Message-ID: <3bb87f6c$1@gaspra.oss.akzonobel.nl>


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

Original text of this message

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