title: How to order data to the right instead of to the bottom in oracle?
body: <p>let say i have this data on my table</p>
  
  <pre><code>select * from user.weekly_job;
  </code></pre>
  
  <p>got :</p>
  
  <pre><code>Staff | JobType
  A | 1
  A | 3
  A | 5
  A | 2
  A | 3
  B | 3
  B | 5
  B | 2
  B | 2
  </code></pre>
  
  <p>but i need all data from staff which contained the occurence of each job type like this :</p>
  
  <pre><code>Staff | 1 | 2 | 3 | 4 | 5
  A     | 1 | 1 | 2 | 0 | 1
  B     | 0 | 2 | 1 | 0 | 1
  </code></pre>
  
  <p>how to do this with oracle query?</p>