title: LISTAGG alternative in Oracle 10g
body: <p>I am kind of newbie in Oracle.
  Got stuck in the below:
  I have the below 2 tables:</p>
  
  <p><strong>Site:</strong></p>
  
  <pre><code>**SiteID|SiteName** 
  1      Sydney
  2      Newyork
  3      Delhi
  </code></pre>
  
  <p><strong>People:</strong></p>
  
  <pre><code>**RecordID|PeopleID|SiteID**
  1         1        1
  2         1        2
  3         2        2
  4         3        1
  5         3        2
  6         3        3
  </code></pre>
  
  <p>Now in my query I want an output something like this:</p>
  
  <pre><code>**PeopleID | AssignedSites**
  1          Sydney,NewYork
  2          Newyork
  3          Sydney,NewYork,Delhi
  </code></pre>
  
  <ul>
  <li>Few more points:</li>
  </ul>
  
  <p>-The solution should work in Oracle 10g as well as 11g also.</p>
  
  <p>-I have given small subset of data in the above example for brevity.But, in my prod scenario, one Person can be associated with 1000+ locations and there could 1000+ such person, so the solution should not break in that case!</p>
  
  <p>Any help will be highly appreciated.</p>
  
  <p>Thanks in advance.</p>