Re: pl/sql aggregation

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Thu, 9 Jun 2005 19:05:57 +0000 (UTC)
Message-ID: <d8a3ul$4sh$1@klatschtante.init7.net>

On 2005-06-07, mark.oliveira_at_gmail.com <mark.oliveira_at_gmail.com> wrote:
> Does anyone know of any built-in PL/SQL functions that will take a
> table like this:
>
>
>
> ID DATA
>
> 1 A
>
> 1 B
>
> 2 C
>
>
>
> And give me this table:
>
>
>
> ID DATA
>
> 1 A, B
>
> 2 C
>
>
> Any help would be great.
>
> Thanks,
>
> Mark

In 10g, there's the collect() sql aggregate function. See my blog at http://www.adp-gmbh.ch/blog/2005/march/28.html for a closer description.

In 9i, you have to use user defined aggregate functions (http://www.adp-gmbh.ch/ora/sql/user_def_agg.html)

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Thu Jun 09 2005 - 14:05:57 CDT