title: Oracle - Return a column per date in a range
body: <p>Let's say I have Table A: assistance</p>
  
  <pre><code>PersonID        Date           CHECK
  123456       2012-01-01          F
  213415       2012-01-03          A
  
  PersonID    ArrivalDate       Jan-01    Jan-02    Jan-03    
  123456       2012-01-01          F       NULL      NULL         
  213415       2012-01-03         NULL     NULL       A          
  </code></pre>
  
  <p>The system is for checks, between 1 to 15 days but no more than that. Any ideas would be very much appreciated.</p>