title: How to create a temporary table as copy of another table in Oracle?
body: <p>I already tried this:</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE tempTable AS
  SELECT * FROM realTable;
  </code></pre>
  
  <p>But then tempTable has only the structure of realTable, but not the elements themselves.</p>