title: CTEs in Oracle 10g - "unsupported column aliasing"
body: <p>I receive the following error when I try to execute a sql statement that uses a CTE:</p>
  
  <pre><code>ORA-32033: unsupported column aliasing
  32033. 00000 -  "unsupported column aliasing"
  *Cause:    column aliasing in WITH clause is not supported yet
  *Action:   specify aliasing in defintion subquery and retry
  Error at Line: 1 Column: 9
  </code></pre>
  
  <p>The code I am trying to execute is:</p>
  
  <pre><code>WITH cte1
  (
    SELECT *
    FROM test_table
  )
  SELECT *
  FROM cte1;
  </code></pre>
  
  <p>I know this is a simple statement and there is no need to use a CTE, but I am just trying to start using CTEs in Oracle (I am coming from T-SQL).</p>
  
  <p>Why doesn't the code execute?</p>