title: Is there a way, in ORACLE, to join multiple row lines into a single one, using two tables, where the final values are separated by commas?
body: <p>Is there a way to join multiple row lines a single one using two tables where the values are separated by commas in ORACLE?</p>
  
  <p>Example:</p>
  
  <h2>Table1</h2>
  
  <pre><code>IdN Name 
  ---------
  1   A 
  2   B 
  3   C 
  </code></pre>
  
  <h2>Table 2</h2>
  
  <pre><code>IdC Car
  ------------
  1    Ferrari
  1    BMW
  2    SEAT
  2    FIAT
  3    FORD
  </code></pre>
  
  <p>Result as:</p>
  
  <pre><code>A    Ferrari,BMW
  B    SEAT,FIAT
  C    FORD
  </code></pre>
  
  <p>I was wondering if there is something like this:</p>
  
  <pre><code>SELECT NAME,CAR
  FROM TABLE1, TABLE2
  where TABLE1.IdN=TABLE2.IdC
  </code></pre>
  
  <p>This returns something like:</p>
  
  <p>A     FERRARI<br>
  A     BMW<br>
  B     SEAT<br>
  B     FIAT<br>
  C     FORD<br></p>
  
  <p>Is there a simple way to "concat" into a row with comma-separated-values ?</p>