title: give month name as column aliase dyanamically in oracle
body: <p>I need month name in column aliase.for example:</p>
  
  <pre><code>select d.Job_name,  nvl(a.cnt,0) as May, nvl(b.cnt,0) as June, nvl(c.cnt,0) as July
  from (query);
  </code></pre>
  
  <p>here I am hardcoding May,June and july as column aliase name.I need them dynamically.</p>
  
  <p>i need below:</p>
  
  <pre><code>select d.Job_name,  nvl(a.cnt,0) as (current_monthe-2), nvl(b.cnt,0) as (current_month-1), nvl(c.cnt,0) as current_month
  from (inner query)
  </code></pre>
  
  <p>Please assist me on this.Let me know if any other information required.Thanks!</p>