title: Create a temp table from a select query -- dbVisualizer vs SQL Developer
body: <p>I've got a query:</p>
  
  <pre><code>SELECT &lt; column names &gt; 
  INTO &lt;#temp_table&gt; 
  FROM &lt; table &gt; 
  WHERE &lt; stuff &gt; 
  </code></pre>
  
  <p>It runs fine in dbVisualizer. However, running it in Oracle SQL Developer gives me the error "The executeQuery method must return a result set."</p>
  
  <p>What is happening here, and how can I fix it in SQL Developer?</p>
  
  <p>EDIT: In response to Tanner, I get the errors when I try the following things (tell me if something I try is invalid. I'm new to SQL):</p>
  
  <p>This:</p>
  
  <pre><code>    select * into #temp_table from status
  </code></pre>
  
  <p>produces this:</p>
  
  <pre><code>    The executeQuery method must return a result set.
  </code></pre>
  
  <p>This:</p>
  
  <pre><code>    select * into #temp_table from status;
      select * from #temp_table;
  </code></pre>
  
  <p>produces this:</p>
  
  <pre><code>    Invalid object name '#temp_table'.
  </code></pre>
  
  <p>And this:</p>
  
  <pre><code>    select *
      from(
        select * into #temp_table from status)
  </code></pre>
  
  <p>produces this:</p>
  
  <pre><code>    Incorrect syntax near the keyword 'into'.
  </code></pre>
  
  <p>I'm lost, ladies and gentledudes.</p>