title: Dynamic column name in Oracle
body: <p>I'm trying to dynamically set a column header.</p>
  
  <p>Here the example:</p>
  
  <pre><code>SELECT Name, COUNT(cars) AS (('cars_from_year_') || year)
  FROM peaple 
  WHERE car = 'GM'
  AND Date BETWEEN (year || '0401') AND (year || '0430');
  </code></pre>
  
  <p>The <code>year</code> should be for ex. 2012 and change (i.e. this being dynamic) for every year (2013,2014,...). </p>
  
  <p>I know the call <code>select to_char(sysdate,'YYYY') from dual</code> but not how to implement it the select statement above?</p>