string aggregation in Oracle 10g

Question

How to aggregate string( concatenate) with Oracle 10g SQL?

Aggregation and concatenation are not quite the same thing. Which did you mean? — FrustratedWithFormsDesigner, Mar 10 '10 at 16:00
what I ment was to aggregate where aggregation function is concatenation. let's say data table looks like this: class text A TEXT1 A TEXT2 B TEXT3 B TEXT4 I would like to have group by query select class, function(text) from TABLE group by class that results with something like: A TEXT1, TEXT2 B TEXT3, TEXT4 — acroa, Mar 16 '10 at 14:15

score 2 · Accepted Answer · answered Mar 10 '10 at 15:59

You could try the collect function:

Some other tricks are here:

...If you actually mean concatenation instead of aggregation then take everyone else's advice and use the || operator between the two strings:

select 'abc'||'def' from dual;

score 1 · Answer 2 · answered Mar 10 '10 at 15:59

1

Oddly enough, it's the "||" operator:

field1 || field2

answered Mar 10 '10 at 15:59

Mike Mooney

score 1 · Answer 3 · answered Mar 10 '10 at 15:59

1

You could use the || operator. Ex: 'First' || 'Second'

Also the function CONCAT(var1, var2) allows you to concatenate two VARCHAR2 characters. Ex: CONCAT('First', 'Second')

answered Mar 10 '10 at 15:59

Ajadex

score 0 · Answer 4 · answered Nov 06 '13 at 09:22

0

There is an undocumented function wm_concat that you can use. Another option would be to roll your own. LISTAGG isn't available in 10g, I think.

answered Nov 06 '13 at 09:22

SQB

JoeG · Answer 5 · 2010-03-10T16:05:08.593

0

Concatenate: CONCAT or ||

Aggregate: COLLECT

edited Mar 10 '10 at 16:05

answered Mar 10 '10 at 16:00

JoeG

5 Answers5