Re: HELP: Database Record Rollup

On 23 Aug 2004, lefebvre_at_iwavesolutions.com wrote:
> I have a source database table that has the form:
>
> ID TYPE TEXT
> 1 1 AAAA
> 2 1 BBBB
> 3 2 CCCC
> 4 2 DDDD
> 5 2 EEEE
>
>
> And I need to output in the following form:
>
> TYPE TEXT
> 1 AAAA BBBB
> 2 CCCC DDDD EEEE
>
>
> Where the TEXT field is concatenated based on type. What SQL
> statement would produce such an output?
>
> Thanks!
>
> Marc

Search here:

http://asktom.oracle.com/pls/ask/f?p=4950:1:

-- 
Galen Boyer