Re: Concat a column?

"Sashi" <smalladi_at_gmail.com> a écrit dans le message de news: f5e766dc-f080-46b6-aa2c-5c7d9336b707_at_q35g2000vbi.googlegroups.com... On Sep 14, 2:51 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Sashi" <small..._at_gmail.com> a écrit dans le message de news: c18a563e-94cf-4f35-8c96-df4d40105..._at_j19g2000vbp.googlegroups.com...
> | Hi All, I'm looking to concatenate multiple values for a single column
> | and am wondering if this is possible.
> |
> | select concat(a1), a2, a3, a4
> | from A
> | group by a2,a3,a4
> |
> | The above will select multiple values of a1. These could range between
> | one value to 10 or 12.
> | I'd like to have them all concatenated, while retaining distinct
> | values of a2,a3 and a4.
> |
> | Is this possible?
> |
> | TIA,
> | Sashi
>
> Search for stragg on AskTom site.
>
> Regards
> Michel

Thanks, Michel.
I've discovered that 10g offers a new function called collect which seems to work similar to the stragg. Here' the link: http://www.oracle-developer.net/display.php?id=306

Regards,
Sashi

It does not concatenate the values, it returns a collection of values. SQL*Plus displays it as it seems the concatenation of the values but it is not. If it makes what you want, good, but it is not what you asked.

Regards
Michel Received on Tue Sep 15 2009 - 11:57:43 CDT