title: Create temporary table
body: <p>I'm coming from SQL Server enviroment where you can declare a temp table with @table, but as I've read you can't do this in oracle.</p>
  
  <p>I want get a value for 500.000 hardcoded id's from a table, but as the IN clause has a limit of 1000 I need to find another way. Is the best way to create a temporary table and insert the hardcoded values and then join the other table which contains the values I need ?</p>
  
  <p>My client (toad) has autocommit set to off and I dont want to commit anything, I want it to be session-based so when I close the database client I want the temporary table do disappear. Is the code below the right way to do in oracle?</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE Test(HardcodedId number(10))
  ON COMMIT DELETE ROWS;
  </code></pre>
  
  <p>I've also tried to use inner join and in the join select the hardcoded values from dual, but this creates a column for each value and i'm not able to use a reference to join with. Is it possible to insert all values into a single column in dual?</p>