title: Oracle column Alias - from keyword not found where expected
body: <pre><code>SELECT col1 'COLUMN 1'
  FROM TABLENAME
  </code></pre>
  
  <p>I am getting an error 'from keyword not found where expected'</p>
  
  <p>How can you give column alias in Oracle 10g some examples are appreciated</p>