title: How to store the result of select statement into the temporary table in Oracle?
body: <p>We can write <code>select column1,column2 into #temp from tableName</code> in SQL Server. But I am unable to write the same query in an Oracle database.</p>
  
  <p>I want to store the result of select/insert/delete/update or any result set into a local temporary table in oracle database. How I can do this?</p>
  
  <p>I am executing below query in my Oracle sql developer tool:</p>
  
  <pre><code>select * into #temp 
  from bmi;
  </code></pre>
  
  <p>but I am getting the error as follow please help to find this error.</p>
  
  <p>when I execute the same query in Microsoft SQL Server it get executed &amp; #temp table get created which is not present in the database but it can hold the data for that particular session. so i want same scenario in ORACLE database.</p>
  
  <blockquote>
    <p>ORA-00911: invalid character
        00911. 00000 -  "invalid character"
        *Cause:    identifiers may not start with any ASCII character other than
                   letters and numbers.  $#_ are also allowed after the first
                   character.  Identifiers enclosed by doublequotes may contain
                   any character other than a doublequote.  Alternative quotes
                   (q'#...#') cannot use spaces, tabs, or carriage returns as
                   delimiters.  For all other contexts, consult the SQL Language
                   Reference Manual.
        *Action:
        Error at Line: 1 Column: 15</p>
  </blockquote>