title: Oracle: How display records from 1 row to many rows
body: <p>I have a problem with records displaying in Oracle.</p>
  
  <p>For example: I have all my records display in one row, like that:</p>
  
  <pre><code>  id| a | a1 | b | b1
    -------------------
    1 |400|  1 |410|  3 
    2 |400| 10 |410| 30
  </code></pre>
  
  <p>But I need, that records would look like that:</p>
  
  <pre><code>  id| code| number
    ----------------
    1 | 400 |  1  
    1 | 410 |  3  
    2 | 400 | 10 
    2 | 410 | 30 
  </code></pre>
  
  <p>Maybe I should use group by function?</p>
  
  <p>Please help me.</p>