oracle sql concatenate results into string
snippet in sql

oracle sql concatenate results into string

user3389

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