Oracle Sql Concatenate Results Into String

[Solved] Oracle Sql Concatenate Results Into String | Sql - Code Explorer | yomemimo.com
Question : oracle sql concatenate results into string

Answered by : vastemonde

-- Concatenates results into one single varchar with separator
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name)
FROM YOUR_TABLE;

Source : | Last Update : Fri, 29 Jan 21

Answers related to oracle sql concatenate results into string

Code Explorer Popular Question For Sql