title: Transform SQL Rows into Comma-Separated values in Oracle
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/468990/how-can-i-combine-multiple-rows-into-a-comma-delimited-list-in-oracle">How can I combine multiple rows into a comma-delimited list in Oracle?</a>  </p>
  </blockquote>
  
  
  
  <p>How can you produce a comma-separated values from list of return rows in SQL without creating a function?  Need to remove duplicates and null or with 'None' as the value.</p>
  
  <p>Example: <code>select name from student;</code></p>
  
  <p>The result : </p>
  
  <pre><code>         NAME         
          ------
          Zed
          Charlo
          None
          Charlo
          Dionn
          Ansay
  </code></pre>
  
  <p>Desired output :  </p>
  
  <pre><code>              Name
               -------
               Zed,Charlo,Dionn,Ansay
  </code></pre>