title: Oracle: create temporary table by a SELECT statement
body: <p>I've tried to mix a CREATE TABLE table_name AS SELECT .... statement with a GLOBAL temporary table statement. They don't mix very well.</p>
  
  <p>Is my example wrong?</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE a AS
  (
     SELECT * from b
  )
  ON COMMIT PRESERVE ROWS;  
  </code></pre>