Re: pl/sql aggregation

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 7 Jun 2005 11:41:38 -0700
Message-ID: <1118169698.695989.209260@g49g2000cwa.googlegroups.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

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions149.htm#sthref1804

with an example by Mrs. Boehmer here:

http://forums.oracle.com/forums/thread.jsp?forum=75&thread=294051&message=919557&q=7379735f636f6e6e6563745f62795f70617468#919557

If before 9i, search asktom for "stragg"

chet Received on Tue Jun 07 2005 - 13:41:38 CDT