combining (concatenate?) rows into one string

[jgmagnus]

hi,

my brain is out of memory. Other than using Cursors, and creating a temporary table of columns, HOW CAN I CONCATENATE ROWS OF THE SAME TABLE TOGETHER TO FORM ONE ROW OR ONE STRING?

thanks!
- magnus

[ngwh]

can u be abit more specific ?? eg... ??

[jgmagnus]

select * from test;

row 1: abcdefg
row 2: abcdefg

I would like to put both rows together on one line like:
abcdefg abcdefg


I'll just use a cursor. I was curious if you could just use SQL or not.
thanks,
Magnus

[pando]

You can but I have to check the book of how to do it. Tom Kyte´s book has a chapter talking about this Pivot tables

[Heath]

Originally posted by jgmagnus
I was curious if you could just use SQL or not.

You can if you know the limit to the number of rows that have to be part of the pivot. There have been multiple threads in these forums about this very thing. You should be able to find the with the search functionality.

HTH,

Heath

[jgmagnus]

FYI -
I attempted to search on this subject with 'concatenating rows'. the problem sometimes is you know WHAT you want to do, but NOT what to search under.

I always search for what I am looking for before I actually post a question. Unfortunately, I didn't know what it was called so i couldn't do a thorough search.

- Magnus

[Heath]

Originally posted by jgmagnus

FYI -
I attempted to search on this subject with 'concatenating rows'. the problem sometimes is you know WHAT you want to do, but NOT what to search under.

Fair enough.

Did you find the threads? I was really busy Friday and didn't have time to do that for you. If you didn't find them, search using the word "pivot". You should find some good examples.

HTH,

Heath