Query to get column value comma separated [duplicate]

Question

Possible Duplicates:
Is there an Oracle SQL query that aggregates multiple rows into one row?
Agregate rows in Oracle SQL statement

I am working with Oracle 10g. I want to have a comma separated String from a column in a table.

e.g.

Table  : Customer        
Columns: id and name

Data:

  id-------name

   1-------John
   2-------Galt
   3-------Howard
   4-------Roark

Output of query should be Jon,Galt,Howard,Roark

I believe my requirement is much simpler than the question in the thread you mentioned. — Sid
– Sid, Commented Jan 31, 2011 at 22:14
Here is another relevant question: stackoverflow.com/questions/1788011/… (and best answer: sqlsnippets.com/en/topic-11591.html ). — Zsolt Botykai
– Zsolt Botykai, Commented Jan 31, 2011 at 22:14
I don't have any grouping to do, I just need the column value extracted to a String. Isn't there a simpler way? — Sid
– Sid, Commented Jan 31, 2011 at 22:16
I believe it's actually a duplicate of stackoverflow.com/questions/2667237/… — Justin Cave
– Justin Cave, Commented Jan 31, 2011 at 22:23
you have plenty of good answers in the comments, and yes, what you are asking to do is "grouping". If you wanted the sum of a set of values you'd group by and use sum(). You're asking for something similar but with strings. — Jim Garrison
– Jim Garrison, Commented Jan 31, 2011 at 22:26

Sid · Accepted Answer · 2011-01-31 22:34:28Z

2

Ok, got it, all I wanted was this:

SELECT WM_CONCAT(NAME) FROM CUSTOMER;

Marking all comments as +1. Thanks guys.

answered Jan 31, 2011 at 22:34

Sid

5,00314 gold badges62 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Justin Cave Over a year ago

Be aware that WM_CONCAT is, technically, undocumented. And it requires that Workspace Manager is installed, I believe.

contactmatt Over a year ago

We use this in production and it works as expected. One thing to note, if relevant at all, Crystal Reports does not like WM_CONCAT when calling it via SQL Expression, even if you're pointing at a Oracle 10 or greater database.

Collectives™ on Stack Overflow

Query to get column value comma separated [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related