Re: HELP: Database Record Rollup

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 24 Aug 2004 07:20:39 -0700
Message-ID: <42fc55dc.0408240620.648e858a@posting.google.com>

AskTom (http://asktom.oracle.com) has a nifty function (user-defined aggregate actually) that you could use. Search the site for "stragg". You could use that function as is and just replace the comma delimiters with your required spaces instead.

Check with your Oracle version as well.

HTH. lefebvre_at_iwavesolutions.com (Marc A. Lefebvre US-775) wrote in message news:<5ef1a86c.0408231541.50a12ce6_at_posting.google.com>...
> 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
Received on Tue Aug 24 2004 - 09:20:39 CDT