title: format column headers during concat,oracle
body: <p>I need to format column headers in the output of sql while using concat
  Eg:</p>
  
  <pre><code>SELECT '' || to_char(sysdate,'ddmmyyyy') as DATE || ',' || ENO|| ',' || NAME|| ''  
  FROM EMP;
  </code></pre>
  
  <p>would retrieve me </p>
  
  <blockquote>
    <p>ORA-00923: FROM keyword not found where expected.</p>
  </blockquote>
  
  <p>Need the output as:</p>
  
  <pre><code>DATE   ENO   NAME
  -----------------
  251013 7560  RAM
  251013 7561  ROSS
  </code></pre>
  
  <p>This format works</p>
  
  <pre><code>SELECT to_char(sysdate,'ddmmyyyy') || ',' || ENO || ',' || NAME as "DATE,ENO,NAME" 
  FROM EMP
  </code></pre>
  
  <p>but I have an issue with </p>
  
  <blockquote>
    <p>ORA-00972: identifier is too long </p>
  </blockquote>
  
  <p>when the length of column names inside as "" exceeds 30 characters</p>
  
  <p>Eg:</p>
  
  <pre><code>SELECT to_char(sysdate,'ddmmyyyy') || ',' || ENO || ',' || NAME ||
         ',' || EMPLOYEE_IDENTIFICATION_NUMBER as "DATE,ENO,NAME,EMPLOYEE_IDENTIFICATION_NUMBER" 
  FROM EMP;
  </code></pre>