title: Display row values as column header
body: <p>I have a <code>select</code> statement</p>
  
  <pre><code>SELECT * 
    FROM TABLENAME 
   WHERE WORKERNAME = 'A'
     AND DATE = '12/17/2014'
  </code></pre>
  
  <p>The output will be:</p>
  
  <pre><code>FREE | USED | DATE      | WORKERNAME
  ------------------------------------
    1  |  0   |12/17/2014 | A
    1  |  0   |12/17/2014 | A      
    1  |  0   |12/17/2014 | A     
  </code></pre>
  
  <p>I need to have an output where outputs for <code>DATE</code> and <code>WORKERNAME</code> will be column header that will look like:</p>
  
  <pre><code>    A
  ----------
  12/17/2014
  ----------
  FREE | USED
  ----------
  1    | 0
  1    | 0
  1    | 0
  </code></pre>
  
  <p>Can someone suggest how this could be achieved using an oracle SQL or PL/SQL?</p>