title: Oracle equivalent to SQL Server STUFF function?
body: <p>Does Oracle have its own implementation of SQL Server <code>stuff</code> function?</p>
  
  <p>Stuff allows you to receive one value from a multi row select. Consider my situation below</p>
  
  <pre><code> ID   HOUSE_REF   PERSON
   1      A         Dave
   2      A         John
   3      B         Bob
  </code></pre>
  
  <p>I would like to write a select statement, but I want the <code>PERSON</code> names to be in a single row.</p>
  
  <p>For example, when I select from this table, I want to achieve the following</p>
  
  <pre><code>HOUSE_REF   PERSONS
  A           Dave, John
  B           Bob
  </code></pre>
  
  <p>I haven't been able to find a simple solution so far, it may be a case of writing my own function to use, but I'm not entirely sure of how to approach this, any ideas?</p>
  
  <p>The main business use of this, will be to have a select statement that shows each house, and against that house to have one column which lists everyone that lives in that house. The house ref in this select must be unique, hence needing to concatenate the persons</p>
  
  <p>Thanks</p>