Search code examples
sqloracle-databasesubquerystring-aggregation

Oracle: Combine multiple results in a subquery into a single comma-separated value

I'm trying to convert a single-columned subquery into a command-separated VARCHAR-typed list of values.

This is identical to this question, but for Oracle rather than SQL Server or MySQL.

Solution

  • There is an excellent summary of the available string aggregation techniques on Tim Hall's site.