title: SQL data convert column to row values
body: <p>I have a table with only one column about 100 rows of only names. But I need to display the 3 names in a row. So that I will get 34 rows each row with 3 names.</p>
  
  <p>Example:</p>
  
  <pre><code>Name
  _____
  
  Raj
  Sam
  Guru
  Tej
  Avin
  Sami
  Fanst
  </code></pre>
  
  <p>I need to display above data as</p>
  
  <pre><code>Name Name1 Name2
  ____ _____ ______
  Raj  Sam    Guru
  Tej  Avin   Sami
  Fanst
  </code></pre>
  
  <p>No condition just need to covert single column value into 3 columns data.</p>
  
  <p>Oracle DB</p>