Oracle - Subquery with concat possible?

is it possible to concat the result of an subquery with oracle?

if this subquery for an view:

  (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

Which returns a list of servernames associated with some kind of system. I need them to display like &qu开发者_如何学JAVAot;Server, Server2, Server3" inside the view.

Any ideas?

this looks like a string aggregation question, see these questions on SO for a description of available methods:

• Oracle: Combine multiple results in a subquery into a single comma-separated value
• Add comma-separated value of grouped rows to existing query
• SQL - Multiple Values comma separated when using GROUP BY