title: how to display the output in oracle with the select query
body: <p>Below is my <code>EMP</code> table with some sample data</p>
  
  <pre><code>EMPNAME | WORK_DATA | WORK_HOURS
  ---------------------------------
  abc     | 01-SEP-13 |     9
  xyz     | 01-SEP-13 |     8
  abc     | 02-SEP-13 |     8
  xyz     | 02-SEP-13 |     7
  abc     | 01-OCT-13 |     5
  xyz     | 01-OCT-13 |     7
  abc     | 02-OCT-13 |     8
  xyz     | 02-OCT-13 |     7
  </code></pre>
  
  <p>And now I want this to be displayed as in oracle using select statement</p>
  
  <pre><code>EMPNAME | SEP_MONTH_WORKING_HOURS | OCT_MONTH_WORKING_HOURS 
  -----------------------------------------------------------
  abc     | 17                      | 13
  xyz     | 15                      | 14
  </code></pre>
  
  <p>Seond doubt is:</p>
  
  <pre><code>EMPNAME | SEP_MONTH_WORKING_HOURS | RANK 
  -----------------------------------------------------------
  xyz     | 15                      | 1
  abc     | 17                      | 2
  </code></pre>