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