title: How can I return multiple identical rows based on a quantity field in the row itself?
body: <p>I'm using oracle to output line items in from a shopping app.  Each item has a quantity field that may be greater than 1 and if it is, I'd like to return that row N times.</p>
  
  <p>Here's what I'm talking about for a table</p>
  
  <pre><code>product_id, quanity
  1, 3,
  2, 5
  </code></pre>
  
  <p>And I'm looking a query that would return</p>
  
  <pre><code>1,3
  1,3
  1,3
  2,5
  2,5
  2,5
  2,5
  2,5
  </code></pre>
  
  <p>Is this possible?  I saw <a href="https://stackoverflow.com/questions/1064077/returning-multiple-rows-from-a-single-row">this</a> answer for SQL Server 2005 and I'm looking for almost the exact thing in oracle.  Building a dedicated numbers table is unfortunately not an option.</p>