title: Sybase Developer Asks: How To Create a Temporary Table in Oracle?
body: <p>I'm familiar with Sybase / SQL server, where I can create a temp. table like this: </p>
  
  <pre><code>SELECT * 
  INTO   #temp
  FROM   tab1 , 
         tab2 
  WHERE  tab1.key = tab2.fkey
  
  SELECT * 
  FROM   #temp 
  WHERE  field1 = 'value' 
  </code></pre>
  
  <p>#temp only exists for the duration of this session, and can only be seen by me.  </p>
  
  <p>I would like to do a similar thing in Oracle, but I'm reading about "global temporary tables", which don't sound like the same thing.  </p>
  
  <p>How can I do the same thing in Oracle as I'm doing in Sybase? </p>
  
  <p>Thanks :)</p>