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

"Sashi" <smalladi (AT) gmail (DOT) com> a écrit dans le message de news: c18a563e-94cf-4f35-8c96-df4d40105802...oglegroups.com...
Search for stragg on AskTom site.

Regards
Michel

On Sep 14, 2:51*pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
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

On Sep 15, 9:22*am, Sashi <small... (AT) gmail (DOT) com> wrote:
Interesting new function. I will have to check it out especially to
see if under 10.2 where it creates the type under the executing user
instead of user sys to see if the feature works when the user does not
have create type privilege.

You can also solve this problem for character columns using a select
that concatenates the columns returned by a series of analytic inline
views outer joined together where each view provides the rows for one
position of the result per partition key. That is view1 returns
column1, view2 return column2, etc ... The row_number function can
be used to order the data by key marking which row is col1, col2,
col3, etc.... The concatenation puts all the columns into one result
set column. You could then join this back to the base table to pick
up other columns of interest.

HTH -- Mark D Powell --

"Sashi" <smalladi (AT) gmail (DOT) com> a écrit dans le message de news: f5e766dc-f080-46b6-aa2c-5c7d9336b707...oglegroups.com...
On Sep 14, 2:51 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
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

On Sep 15, 12:57*pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
You're right. It's a collection and no a concatenation. However, it
suits my needs for now and is good enough.
Thanks,
Sashi