Oracle - Subquery with concat possible?

Question

Is it possible to concatenate the result of a subquery using an oracle?

if this subquery to represent:

(SELECT s.name FROM app_shared_servers ass LEFT JOIN servers s ON (s.srv_id = ass.srv_id) WHERE ass.app_id = a.APP_ID) SHARED_SERVERS 

Returns a list of server names associated with a system. I need them to appear as "Server, Server2, Server3" inside the view.

Any ideas?

Answer 1

this looks like a row aggregation question, see these questions in SO for a description of the available methods:

• Oracle: combine multiple results in a subquery into a single value, separated by commas
• Add comma-separated value of grouped rows to existing query
• SQL - Multiple values ​​separated by commas when using GROUP BY