title: Pl/SQL - oracle 9i - Manual Pivoting
body: <p>We have a table which has three columns in it:</p>
  
  <pre><code>Customer_name, Age_range, Number_of_people.
  1              1-5         10
  1              5-10        15
  </code></pre>
  
  <p>We need to return all the number of people in different age ranges as rows of a single query. If we search for customer #1, the query should just return one row:</p>
  
  <pre><code>Header- Age Range (1-5)             Age Range (5-10)
          10                             15
  </code></pre>
  
  <p>We needed to get all the results in a single row; When I query for customer 1, the result should be only number of people in a single row group by <code>age_range</code>.</p>
  
  <p>What would be the best way to approach this?</p>