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 for

"User-Defined Aggregate Functions", "janik (AT) pobox (DOT) sk"

in comp.databases.oracle.* for an example


lefebvre (AT) iwavesolutions (DOT) com (Marc A. Lefebvre US-775) wrote in message news:<5ef1a86c.0408231541.50a12ce6 (AT) posting (DOT) google.com>...

On 23 Aug 2004, lefebvre (AT) iwavesolutions (DOT) com wrote:
Search here:

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

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 (DOT) com (Marc A. Lefebvre US-775) wrote in message news:<5ef1a86c.0408231541.50a12ce6 (AT) posting (DOT) google.com>...