title: How can I query to get the rows according to the certain column's value in oracle?
body: <p>Table A is:</p>
  
  <pre><code>--------------
  C1      C2
  --------------
  A       3
  B       2
  --------------
  
  select * from
  (
      select 'A' as C1, 3 as C2 from dual
      union all 
      select 'B' as C1, 2 as C2 from dual
  )
  </code></pre>
  
  <p>I want to get the following result view with one query statement:</p>
  
  <pre><code>--------------
  C1    N1
  --------------
  A      1
  A      2
  A      3
  B      1
  B      2
  --------------
  </code></pre>
  
  <p>I need to generate rows as many as C2 value </p>
  
  <p>Is this possible?
  Thank you.</p>