title: Oracle - Subquery with concat possible?
body: <p>is it possible to concat the result of an subquery with oracle?</p>
  <p>if this subquery for an view:</p>
  <pre><code>  (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
  </code></pre>
  <p>Which returns a list of servernames associated with some kind of system. I need them to display like &quot;Server, Server2, Server3&quot; inside the view.</p>
  <p>Any ideas?</p>