Concatenating text data in a column using SQL

Question

Does anyone know how to concatenate all the values of a column in a query using SQL only? I know that there are ways using database specific tools such as pivot, but I don't think I have access to something like that in infomaker.

I am using infomaker to produce labels for sample bottles. The bottles can be analysed for more than one thing. If I join the bottle and analysis tables I get several rows per bottle which results in multiple labels, so I was hoping to concatenate all the values for the analysis using SQL and then use a computed value based on this to add something useful to the label. I can only use 1 transaction based on a select query to do this.

Adding additional tables or columns to the database would be highly discouraged.

@scaisEdge I am using oracle, but through a connection from infomaker. — Graham Anderson, Sep 08 '16 at 19:34
@AndrewJenkins I need to concatenate the values for multiple rows of 1 column, rather than multiple columns of 1 row, — Graham Anderson, Sep 08 '16 at 19:36

score 0 · Answer 1 · answered Sep 08 '16 at 19:42

0

In some oracle version you can use wm_concat

SELECT field1, wm_concat(field2) FROM YourTable 
GROUP BY field2;

otherwise you can use listagg

answered Sep 08 '16 at 19:42

ScaisEdge

131,976
10
91
107

Concatenating text data in a column using SQL

1 Answers1