Oracle - Subquery with concat possible?

Question

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 "Server, Server2, Server3" inside the view.

Any ideas?

score 5 · Accepted Answer · edited May 23 '17 at 10:28

5

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

edited May 23 '17 at 10:28

Community

1
1

answered Nov 24 '10 at 10:54

Vincent Malgrat

66,725
9
119
171

Oracle - Subquery with concat possible?

1 Answers1