Re: Concat a column?
From: Sashi <smalladi_at_gmail.com>
Date: Tue, 15 Sep 2009 06:22:17 -0700 (PDT)
Message-ID: <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
Date: Tue, 15 Sep 2009 06:22:17 -0700 (PDT)
Message-ID: <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
Received on Tue Sep 15 2009 - 08:22:17 CDT