title: How to transpose rows into columns
body: <p>I have the following data in Oracle</p>
  
  <pre><code>Number   Text
  12345    ab 
  12345    abc   
  12345    acbd
  </code></pre>
  
  <p>How can I convert it to become:</p>
  
  <pre><code>Number   Text1 Text2 Text3
  12345    ab    abc   abcd  
  </code></pre>
  
  <p>How to do this using SQL in Oracle?</p>